Database Compare Suite™
- Overview
- Product features
- Getting started
- Connecting to server
- Connecting to an Amazon DynamoDB database
- Connecting to an Amazon Redshift database
- Connecting to an Apache Cassandra database
- Connecting to an Azure SQL Database
- Connecting to an Azure Synapse Analytics data warehouse
- Connecting to a BigQuery data warehouse
- Connecting to a Greenplum database
- Connecting to an IBM DB2 database
- Connecting to an IBM Netezza database
- Connecting to a MariaDB database
- Connecting to a Microsoft Access database
- Connecting to a Microsoft SQL Server database
- Connecting to a MySQL database
- Connecting to an Oracle database
- Connecting to a PostgreSQL database
- Connecting to a Snowflake database
- Connecting to a Sybase ASE database
- Connecting to a Sybase IQ database
- Connecting to a Teradata database
- Connecting to a Vertica database
- Installing the required database drivers
- Creating a new project
- Opening an existing project
- Key activation
- User interface elements
- Connecting to server
- Operations in details
- Schema comparison
- Schema synchronization
- Schema operations options
- Data comparison
- Detailed data comparison
- Fast data comparison
- Data synchronization
- Data migration
- Settings comparison
- Virtual views
- Sorting key selection
- Selecting operation scope
- Matching
- Matching rules
- Fast data comparison options
- Data operations options
- Command-line interface
- Settings
- Requirements
- Known issues
- Support
Matching
Data matching is the first and, perhaps, the most important step for all data operations. The Database Compare Suite application automatically creates object pairs by names, but you still can specify them manually if necessary.
Uncheck objects in the matched pair to exclude them from the following operation.
Please note that the unmatched objects are are highlighted in yellow. You can see the number of matched and unmatched objects on the right side of the object name.
Choose the objects you want to manually match from the pop-up window, which appears when you click on the Match button
.
Use Ctrl or Shift keys to select multiple objects for one-to-many matching. The object highlighted in bold must be included into the one-to-many matching.
Press the Unmatch button
to unmatch the objects manually.
Use the Filters button
at the top left-hand corner of the matching window to customize the list of objects, represented in the tree view.
Press the Reset button
to launch automatic matching for objects after changes in settings have been made.
Press the Loading messages button to review the messages occurred when loading metadata from source and target databases.
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].