upgrade against multiple Databases with different versions?

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

upgrade against multiple Databases with different versions?

Postby dbdmora » Mon Jun 18, 2012 9:11 pm

Hello, I have over 100 remote locations that have the same databases and schema. We might have some locations that might be missing an extended property or something very small. Is possible to create a SQL packager that will get our \"gold\" copy and update/upgrade our remote locations even if our remote locations are not all the same? I don't want to make 100 different packages because some remote locations might have slight differences in the database. It is almost like running a sql compare and updating the differences but want to do it via SQL Packager.

Thanks
dbdmora
 
Posts: 34
Joined: Mon Nov 21, 2011 9:55 pm
Location: Atlanta, GA

Postby james.billings » Wed Jun 20, 2012 2:07 pm

Thanks for your post.

This is a fairly common question actually - the problem is that the script Compare (which is used behind the scenes by Packager) generates is based on the two databases at the time the comparison was done. If you then try to run the same update on a database that's different, then it becomes unpredictable - on some occasions it may still function, but equally there are lots of differences that will cause the script to fail. So really, you need to be able to run the comparison against the target database.

Currently, Packager doesn't offer this sort of ability. The usual workaround is to investigate our Comparison SDK, and generate an application that can be deployed to your target sites to compare and update the databases directly. You can deploy your updated \"standard\" database along with your app as either a backup file or a set of scripts that the app would compare to at runtime.

There's plenty of examples here if you do want to investigate this.

An SDK license initially allows you to deploy your app to 10 sites, but our sales team are happy to discuss discounts for \"bulk orders\"
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests