abhisinghal21 on Mon, 15 Sep 2014 09:57:13
We are moving from a simple client-server winforms application to winforms client + wcf service + sql azure.
One of the things in the cloud world is that the updates are much more frequent and all customers generally stay up to date with the latest changes.
Now suppose we have a development database (could be an azure database itself) .
In the ideal world, we would make changes to this database , click on a "push schema" button and all schema changes since the last push would be propagated to all customer databases.
OK - so the question is - what is the best way to sync schema changes from development database to customer production databases ?
Shirisha Paderu on Mon, 15 Sep 2014 14:05:10
You may use SQL server Publishing wizard to produce SQL scripts of the changes which is one of the easiest approach.
please check if this helps : SQL Server Publishing Wizard.
abhisinghal21 on Tue, 16 Sep 2014 07:35:21
So essentially the strategy is the same as in conventional sql server databases.
Generate database updation script and execute it against each azure database.
The most common issue faced in the script generation is the mapping of renamed columns and tables.
I was thinking that since this is a very common task, with such an increased frequency in the cloud era, there would be a more automated way of managing database schema updates across several customer databases of same schema.