How to compare and synchronize SQL Server database schemas

This tutorial shows how to compare and synchronize SQL Server and Azure databases using the Schema Compare tool in dbForge Studio. It provides step-by-step instructions for setting up comparisons, managing schema differences, mapping tables, and deploying synchronization scripts.

Timestamps

0:00 Introduction.

0:14 Create a new comparison project.

0:40 Configure comparison options, schema mapping, and table mapping.

1:08 Get schema comparison results.

1:45 Launch the synchronization wizard.

2:10 Check deployment options.

2:37 Review and run the synchronization script.

3:07 Conclusion.