Comparing Database Data
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.