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
sql-server database-schema azure azure-sql-database


source to share


No one has answered this question yet

Check out similar questions:

3491
How can I UPDATE from SELECT in SQL Server?
2603
Add column with default value to existing table in SQL Server
1787
How can I concatenate text from multiple strings into one text string in SQL Server?
1770
How do I check if a column exists in a SQL Server table?
1658
How to return only date from SQL Server DateTime datatype
1433
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
1005
Check if a table exists in SQL Server
907
How can I execute an UPDATE statement with JOIN in SQL?
793
Update table using JOIN in SQL Server?
560
What's the best way to automatically generate INSERT statements for a SQL Server table?



All Articles
Loading...
X
Show
Funny
Dev
Pics