Skip to main content

Synchronize Development and Production Servers

We have seperate development and production database servers. The goal is to sync the databases schemas and data for both environment.

Servers​

Development 192.168.11.31​

Used during development and for staging.

Production 10.16.0.6​

Used for production.

When working remotely, you should work through the Remote Desktop by connecting to 192.168.11.32 virtual machine.

DB Comparer

Synchronizing Databases Schemas​

DB Comparer for SQL Server​

  1. Open Project > New Project
  2. Setup the Source and Target databases with login credentials

DB Comparer DB Comparer 3. Review the comparasion results

DB Comparer

  1. Resolve Differences > Right Click > Execute All Scripts DB Comparer DB Comparer handles creating the required SQL scripts for tables, views, procedures,...

    You can still review or edit the scripts before executing.

  2. Full Recompare after execution to verify the changes.

Synchronizing Data​

Data Comparer for SQL Server​

Similar to the DB Comparer, you have to enter the servers credentials and select the database to compare.

  1. Select the tables you want to compare, you can compare more that one table at the same time
  2. Optionally set a filter (works like a WHERE clause). Note that if you do not set a filter for the table, all the records will be compared and possibly synchronized.

Data Comparer

Data Comparer

  1. Review compare summary

Data Comparer

  1. Follow the steps by clicking on the Next button
  2. Finally, the Synchronize button will insert/update the compared records.
  3. Recompare to view the changes Data Comparer