Following the article How to Compare Data in SQL Server Databases, here you will find a detailed description of how dbForge Data Compare for SQL Server further copes with data synchronization of SQL Server databases.
How it works?
Synchronization process establishes data consistency between Source and Target databases, during which distinct records from the Source database are automatically transferred to the Target database.
Stages of data synchronizationAfter you have compared and analysed the differences between Source and Target databases and selected the tables for synchronization, you can proceed to the synchronization step.
1. Click Synchronize on the Comparison toolbar.
2. Data Synchronization Wizard opens suggesting you three options. You can generate a script to synchronize data from Source database to Target database or vice versa. Alternatively, you can save the script to a file and execute it later. The third option is to execute the script directly against the Target database. We recommend you to play on the safe side and select the option Open the synchronization script in the internal editor to be able to see the changes that will be executed against the Target database and make some corrections if required. Click Next.
As you can see, dbForge Data Compare for SQL Server makes the whole process of data comparison and synchronization simple and self intuiting. In this article, we have touched upon most salient features of the tool. However, there are many other powerful features that will be useful for database administartors and developers.