Red Gate forums :: View topic - SQL Package via the Internet
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

SQL Package via the Internet

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rodriguezja



Joined: 13 Apr 2010
Posts: 4

PostPosted: Tue Apr 13, 2010 5:50 am    Post subject: SQL Package via the Internet Reply with quote

I'm looking at building an application that connects to a database on the internet and updates the local copy of the database via a click of a button. Is SQL Packager able to do that? If so, are there samples? I know that it can generate .NET code and projects and run via command line. What I want is to integrate it as part of our application so that as far as the user is concerned, updating of their data would be seemless.

Is this possible? Thanks!
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Wed Apr 14, 2010 5:16 pm    Post subject: Reply with quote

Unfortunately, we do not have a code sample for this sort of thing. It could probably be done if you can have a SQL connection (port 1433) between the internet database and the user's database. Otherwise you could not get the schema and data of both databases to be compared.

If that were possible, you could use the command-line version of packager or the SDK to build an executable on the fly at the web server and deploy it to the client with clickonce. As I said, though, I haven't tried it myself. Some Packager fans have used clickonce deployment, though -- I think there is a forum topic or two about it.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group