upgrade against multiple Databases with different versions?
dbdmora
Posts: 50
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
Thanks
Comments
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"
Redgate Software