SQL Package via the Internet

Forum for users of SQL Packager database archive utility

SQL Package via the Internet

Postby rodriguezja » Tue Apr 13, 2010 4:50 am

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!
Posts: 4
Joined: Tue Apr 13, 2010 4:44 am

Postby Brian Donahue » Wed Apr 14, 2010 4:16 pm

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest