Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I synchronize metadata and data between different SQL Server versions?

April 26, 2017Data different metadata SQL Server synchronize versions

0

Posted

Can I synchronize metadata and data between different SQL Server versions?

1 Answer

0

Posted

You can use DB Comparer for SQL Server tool to synchronize the structure of your databases. To launch DB Comparer from STUDIO, please, choose Data Analysis tab and click on DB Comparer for SQL Server, or go to Start->Programs->EMS->SQL Studio for SQL Server-> DB Comparer for SQL Server-> DB Comparer for SQL Server. To synchronize the data, you can use Data Comparer for SQL Server tool. To launch Data Comparer from STUDIO, choose Data Analysis tab and click on Data Comparer for SQL Server, or go to Start->Programs->EMS->SQL Studio for SQL Server-> Data Comparer for SQL Server-> Data Comparer for SQL Server.