dbForge Data Compare for SQL Server is another useful app in the set of tools intended especially for database administrators. With it, you can create data comparisons and synchronizations of different SQL Server databases. It has a clean user interface, enabling users to quickly find and navigate between different options.
When installing the app, you will be prompted to associate .sql and .dcomp files with the app. Installer will also ask you, if you want to generate native images, which will speed up the app startup process.
For creating a new data comparison, we must specify a source and a target database. We can also customize criteria for comparison, such as, if we want to compare tables, views, ignore cases, and similar. We can also use native SQL Server backups in comparison process.
After receiving the comparison results, we can then perform synchronization between the two data sources, by using the Data Synchronization wizard. If we need to store comparison results for later use, we can also create a data comparison reports and save them to different formats, such as Excel and HTML.
All in all, a must have tool for someone who needs to compare and synchronize between different SQL Server databases. It works with all SQL Server editions, from 2000 to 2016. It also integrates with SQL Server Management Studio 2016, so if you are using this solution for SQL Server management, you can use dbForge Data Compare for SQL Server directly from its interface.
