Before Azure Data Studio, SQL Server developers could only use third party SQL comparison tool such as Redgate SQL Compare to compare and synchronize SQL Server database schemas between two databases either in the same server instance or remote instances. Starting from Azure Data Studio (ADS), there is a FREE ADS extension Schema Compare provides an easy-to-use way to compare two database definitions and apply the differences from the source to the target. This includes active database connections, dacpac files, and SQL projects.
After this extension is enabled, right-click the source database under CONNECTIONS > SERVERS, then choose Schema Compare.
Click the [...] button besides Target to select the target database:
Press the Compare button to start the schema comparison:
After the comparison is completed, the comparison result will be shown. Then you can press the "Generate script" button to generate the deployment script.
No comments:
Post a Comment