Synchronize views and queries

Synchronize views

Views can be synchronized with Data Compare for SQL Server only if:

  • They reference rows from a single table
  • They don’t include IDENTITY or computed columns

To synchronize views that reference more than one table:

1. Compare the views with Data Compare. When configuring the comparison options in the New Data Comparison Wizard, make sure that the Compare views option is selected.

2. Notice which rows are different.

3. Use the Data Compare for SQL Server tool to compare and synchronize the tables with the differing rows.

Synchronize queries

You cannot directly synchronize queries with Data Compare. But you can get an update script and apply it against a target database instead.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?