Update changes in local SQL server db to Sql Azure db immediately?

Until now, when I made any changes to my local Db to make those changes to sql azure db, I need to manually write a script and run it on sql azure db. Is there some solution to help update sql azure db faster? How will my sql azure db get updated automatically after I check my code for original control? I have one Db project in my solution. I have heard about Redgate, which may have some products that might solve my problem, but I'm not sure. Any suggestion?

Ps: If this question does not fit, ask here, please provide it to me so I can remove it.

Edit: There is another way that I usually use is to compare the schema between db project and sql azure db and then update. This way I don't have to write the script by hand, but I still need to take a few steps to get the db in an updated azure look.

+3


source to share





All Articles