Wednesday, 11 September 2013

What's the best way to automate the process of updating multiple schema-identical databases?

What's the best way to automate the process of updating multiple
schema-identical databases?

We're using a Visual Studio database project to manage our schema. Our
current process of managing out-of-date db's is to run the VS
schema-comparison tool against a database, preview changes, and finally
generate/run an update script.
The problem is that we have to do this for each database and it doesn't
scale well.
Does anyone have any suggestions here that can provide for a bit more
automation?
Thanks in advance!

No comments:

Post a Comment