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
Fast data comparison options
While performing fast data comparison operation, you get to the Fast data comparison options page. Here you can manage data options and set the hash function parameters.
In the left side of Options window, you can see the objects tree of matched object items (tables, views, and columns).
Modified options are located on the right side of the window, and they depend on the chosen node of the objects tree.
Please note that changing settings in the Default Options node (at the top of the objects tree) will affect all pairs of data objects in current operation.
You can change options for the desired pair of data objects. To do so, select them from the objects tree on the left side of the window.
Please note that the names of the selected objects are bold, as well as the names of their parent objects.
Available for modification options will be shown at the right side. If there are no options available for modification for the selected pair, you will get the corresponding message.
You can opt for comparing just the row count in data objects (tables, views, etc.).
Check the Compare only row count option to run the Fast Data Comparison operation really fast.
In this case, Database Compare Suite will not calculate the hash for the tables, simply comparing the row count.
Please note that you can’t use this option to validate data migrations.
You can exclude computed columns from the fast data comparison operation.
Check the Exclude computed columns option to do that.
In this case, Database Compare Suite will not calculate the hash for these computed columns.
You can exclude some columns from fast data comparison operation. Use the following options block at the top of the right side:
Check the Time option to exclude the time columns from hash or checksum function.
Check the Date Time option to exclude the date time columns from hash or checksum function.
You can set the number of symbols to use in comparison for objects of strings and binary types for the homogeneous operations (when the source and the target use the same database platform). Use the Number of symbols to hash block of options:
Check the Trim string types option to trim the string type objects. Set the maximum length for the string type objects in the corresponding edit box. The first N symbols of the string will be used in the comparison.
Check the Trim binary types option to trim the binary type objects. Set the maximum length for the binary type objects in the corresponding edit box. The first N bytes of the string will be used in the comparison.
Please note that this option is available only for the homogeneous database operations.
The following options are available only for the heterogeneous operations (when the source and the target use different database platforms).
Select the trimming mode type from the drop-down list.
Use the Trailing option to trim spaces at the end of string values before comparison.
Use the Both option to trim spaces at the beginning and the end of string values before comparison.
- Check the Trim VAR strings option to trim the objects of the variable length string data type.
Please note that these trimming options are available only for the heterogeneous operations (when the source and the target use different database platforms).
Select the floating point comparison type from the drop-down list.
Check the Accurate option to use the algorithm that converts float numbers to the exponent format. This allows for eliminating issues with rounding of the float numbers during calculations. These issues may be caused by the various formats used for data storage in the different database platforms.
Check the Fast option to process floating numbers as fixed-point numbers.
Please note that this option is available only for the heterogeneous operations (when the source and the target use different database platforms).
Click the Reset button
to restore default parameters for all modified options.
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].