How to synchronize two schemas quickly

This topic explains how to perform a simple database schema comparison and synchronization.

Compare schemas

1. Click New Schema Comparison in the Database Design section of Start Page. The Schema Comparison wizard opens.

2. Select the Source and Target connections.

Note

You can edit selected connections or create a new one by either clicking the Edit button or the New button.

To quickly compare schemas, you can click the Compare button immediately after setting databases and skip step 3.

3. To adjust comparison process, set the comparison options.

Synchronize schemas

1. Analyze comparison results and select the database objects you want to synchronize by selecting the corresponding check boxes.

2. Select the data to synchronize in the grid with comparison results.

Note

To do this, select check boxes next to the tables (or views) in the top grid. You may also select check boxes next to the individual records on the Only in Source, Only in Target, and Different Records tabs of the bottom grid.

3. Click the Synchronize button on the Comparison toolbar to open the Schema Synchronization wizard.

4. Select where to display the synchronization script in the wizard and click the Synchronize button.

Want to Find out More?

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.

Ready to start using dbForge Studio for SQL Server?

Download a free 30-day trial