Red Gate forums :: View topic - upgrade against multiple Databases with different versions?
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

upgrade against multiple Databases with different versions?

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



Joined: 21 Nov 2011
Posts: 33
Location: Atlanta, GA

PostPosted: Mon Jun 18, 2012 9:11 pm    Post subject: upgrade against multiple Databases with different versions? Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Jun 20, 2012 2:07 pm    Post subject: Reply with quote

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"
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