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
Modifying comparison of string values
When comparing string values, various problems can appear. For example, data values can be case-sensitive, and data fields can have leading or trailing spaces. In this case you have to manage the options for text data types correctly to avoid problems in data comparison.
In the data options section, you can specify options for the text data types:
Select Trimming mode from the drop-down list. Here are the options you can specify:
- None — the application will compare all string values without modifications;
- Leading — the application will trim the leading spaces in all string values before comparison;
- Trailing — the application will trim the trailing spaces in all string values before comparison;
- Both — the application will trim both leading and trailing spaces in all string values before comparison.
- Ignore White Spaces — the application will split string values into tokens by white spaces. Then the application will compare these collections of tokens. Specifying this option may significantly decrease the operation speed.
- Here are the examples of using different values for the Trimming mode option. Let’s compare the values ” Information ” and “Information “:
Trimming mode Value 1 Value 2 Result None "Information"
"Information"
Not equal Leading "Information"
"Information"
Equal Trailing "Information"
"Information"
Not equal Both "Information"
"Information"
Equal
- Check the Ignore case option to ignore case matching during data comparison operation. If the checkbox is unchecked, the data comparison will be case-sensitive.Here are the examples of using different values for the Ignore case option. Let’s compare the values “Text” and “text”.
Ignore case Result Unchecked Not equal Checked Equal - Click the Reset button
to restore default parameters for all modified options.
- Please note that the operation properties are stored by the application for the entire project, so all changes to the operation settings that you have made will be automatically used for all objects of the same type in your project.
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].