Export (0) Print
Expand All

Comparing Database Data

Visual Studio 2005

By using Team Edition for Database Professionals, you can compare the data in two databases. Team Edition for Database Professionals also generates Data Manipulation Language (DML) scripts that you can use to update the data of the target database to match the data that is contained in the source database.

You can use Team Edition for Database Professionals to compare Microsoft SQL Server 2000 and Microsoft SQL Server 2005 databases. 

In This Section

Overview of Comparing Database Data

Describes aspects of the data-comparison functionality in Team Edition for Database Professionals. 

How to: Compare the Data of Two Databases

Describes how to compare the data in two databases.

How to: Set Options for Comparing Database Data

Describes how to set options that determines what is considered a difference when you compare the data between two databases.

How to: View Data Differences

Describes how to interpret the data that Team Edition for Database Professionals displays after it compares the data in two databases.

How to: Synchronize Database Data

Describes how to propagate selected data from the source to the target.

Walkthrough: Comparing the Data of Two Databases

Provides a detailed, step-by-step description of a comparison of data in two databases.

Related Sections

Comparing Database Schemas

Describes how to compare the schema, or structure, of two databases or of a database and a Visual Studio database project. 

Show:
© 2014 Microsoft