only
$369
  • Save Time. Eliminate Errors.

    This simple yet effective tool supports over a dozen database platforms and helps automate the following processes:

    • Verify successful database migration and replication
    • Explore differences in database schemas
    • Compare two database tables and views
    • Optimize DevOps routine by running all operations in Command Line Interface (CLI)
    • Migrate data between different database environments (for example, from development to production)
    • Simplify schema and data manipulation tasks in both homogeneous and heterogeneous database environments
    • Restore specific database objects instead of a full backup
    • Migrate databases and applications from on-premises to the cloud

    Benefits

    DB Best Database Compare Suite has a user-friendly interface and doesn’t require any specific database experience from the users. In addition to that, our tool provides users with the following benefits:

    • Speed up verification process when moving to production environment
    • Detect database changes and address them right away
    • Upscale your database migration and upgrade projects
    • Simplify operational data management
    • Avoid human factor and possible errors with full automation of operations
    • Perform comparison and synchronization operations with command-line interface
    • Improve your DevOps pipelines, version control, etc.

    Features

    We at DB Best understand the importance of data and the pain of data loss or corruption. So, we created a tool that you can trust when it comes to data operations, such as comparison, migration, synchronization, verification, integrity checks, and many others.

    Find the list of key Database Compare Suite features below.

    Schema comparison

    Compare database schemas and identify differences in tables, views, triggers, stored procedures, functions, packages, synonyms, rules, etc. The schema comparison operation takes into account specifics of all supported dialects.

    Schema synchronization

    Synchronize database schemas between different environments or even migrate databases from one platform to another. Database Compare Suite generates a synchronization script based on the results of the schema comparison operation.

    Data comparison

    Compare data in 2 selected tables or views to quickly discover whether they are equal or not. You can run this operation against databases with equal or close-to-equal database schemas regardless of the source and target platforms.

    Fast data comparison

    For big volumes of data, the fast data comparison operation quickly checks whether the tables are not equal or not. The result is based on the value, returned by the hash function, so, the detailed comparison results are not available.

    Detailed data comparison

    Discover the exact differences in data stored in 2 tables or views. Database Compare Suite highlights the rows and columns with differences. You can easily navigate through the differences and synchronize data if needed.

    Data migration

    Migrate data from the source table to the target table regardless of the database platforms. Use caution when migrating data as this ope ration clears the data in the target table and then uploads the data from the source table.

    Data synchronization

    Add missing data from the source table to the target table. The tool populates the target table with missing data from the source table. Unlike the data migration operation, this operation doesn’t overwrite data in the target table.

    Settings comparison

    Compare server or database settings of two Microsoft SQL Server databases. This feature may come in handy for Microsoft SQL Server upgrade projects as you can run this operation between different versions of SQL Server.

    Command-line interface

    Database Compare Suite includes both GUI and CLI versions. You can utilize a command-line interface to automate the execution of different data management tasks, DevOps operations, and verification of migration or upgrade.

    NoSQL databases support

    Database Compare Suite supports both relational databases and NoSQL databases such as Amazon DynamoDB and Apache Cassandra. You can compare, migrate, and synchronize data between NoSQL databases and a relational counterpart.

    Cloud databases support

    You can use Database Compare Suite to connect both to on-premises and cloud databases. Microsoft Azure, Amazon Web Services, Google Cloud Platform, you name it. Database Compare Suite is always there to help you manage data.

    Data Warehouse support

    You can use Database Compare Suite to manage Bid Data storage like Azure Synapse Analytics, Amazon Redshift, Netezza, Greenplum, and Teradata. Be sure to use fast data comparison operation to compare data in a blink of an eye.

    Queries execution

    Run queries against the selected database object in the database metadata tree. You can execute queries execution against the source and target databases and then compare the results to validate database code migration.

    Objects matching

    You can manually match two objects in source and target databases. This allows for comparing database schemas, tables, or any other objects with different names. So, you can ignore specific prefixes of different environments.

    Type mapping

    If the target database doesn’t support the same data type as the source database, you can map types manually to carry on the comparison operation. You can rely on default type mapping, which is based on industry best practices.

    20 database platforms supported

    Database Compare Suite allows for comparing data and schema across all supported database platforms.

    • Microsoft SQL Server
    • Azure SQL Database
    • Azure Synapse Analytics
    • Oracle Database
    • PostgreSQL
    • SAP ASE
    • IBM DB2
    • MySQL
    • Amazon Redshift
    • Teradata
    • Greenplum
    • Netezza
    • SAP IQ
    • Vertica
    • Apache Cassandra
    • Amazon DynamoDB
    • Microsoft Access
    • MariaDB
    • BigQuery
    • Snowflake

    Using Database Compare Suite

    Database Compare Suite supports a record number of on-premises and cloud database platforms, including relational, NoSQL databases, and the most popular Data Warehouse platforms. The product’s highly customizable features make it a must-have tool for any database professional, developer or tester who works with data.

    Scenarios Database Compare Suite features Roles

    Development of data-driven applications using a single database platform

    • Compare databases between dev/test/stage/production environments OR between different instances of production environments. Apply changes to the target.
    • Compare databases after deploying new releases.
    • Automate comparison and deployment of differences between dev/test/stage environments.

    Developers, DBAs, QA, DevOps

    Development of applications with cross-database
    support
    (supporting multiple database platforms)

    • Compare data between heterogeneous data sources with high accuracy, considering data types, precision, and data structure difference between database platforms. Apply changes to the target.

    Developers, DBAs, QA, DevOps

    Database upgrade

    • Compare database schema, data, and settings before and after an upgrade.
    • Validate data consistency for compliance after any change.

    Developers, DBAs, QA, IT Managers

    Data migration

    • Compare and validate data between the source and the target after migration. Quite often a verification is needed to validate that the original dataset was not corrupted.

    DBAs, QA, IT Managers

    Database migration

    • Compare database schema & data before & after database migration. Apply changes to the target.

    Developers, DBAs, QA, DevOps

    Automation

    • Integrate any of the product features into automation scripts using CLI.

    DBAs, Database developers, QA, DevOps

    Database Compare Suite Features

    Discover the endless possibilities of our unique database migration tool.

    Database Compare Suite Overview

    Learn more about a powerful and simple tool that every DBA and database developer needs.

    Interface Elements Workspace

    This is the main application window. In this window, users can select the scope of their operation (highlight a few objects in the metadata tree to the left and right) and the operation itself (second, third, and fourth buttons on the top toolbar).

    Matching Success

    The matching page is designed to map objects to perform the operation. By default, the comparison is done automatically by the type and object name. If automatic mapping does not provide suitable relevant pairs of objects, users can manually perform the matching.

    Options

    The data options page contains a tree of matched object items (tables, views, and columns) and an item for default options on the left side of the window. Comparison options are located on the right part of the window. Options collection depends on the type of selected tree item. Any change in default options will affect all pairs of data objects in current operation unless you changed options for a specific pair of data objects.

    Settings Comparison

    The "Settings Comparison" operation compares server or database settings of two MS SQL Server instances. The result of the comparison shows all available settings for the selected pair of servers or databases.

    Detailed Data Comparison Result

    The detailed data comparison operation compares data of Data Objects pairs (tables or views). The Results page displays all rows with differences.

    Schema Sync Window

    The synchronization schema operation allows users to make target object schema equivalent to source object schema. The intermediate result of the schema synchronization operation is the metadata tree containing different objects (the upper part of the window with the result) and scripts to synchronize (the lower part of the window).

    System Requirements

    General

    Operating system

    Windows Server 2008; Windows Server 2012; Windows 7 or higher.

    Available disk space

    100 MB

    Additional software

    for Oracle

    Oracle Data Access Components (ODAC) with Oracle Data Provider for .NET version 9.2 or higher

    for SAP ASE

    One of the following providers:

    Sybase ASE OLE DB Provider 12.5 or higher
    Sybase ODBC Provider

    for Vertica

    Vertica ODBC provider

    for IBM DB2

    IBM Data Server Client Version 9.7 Fix Pack 81 or higher

    for PostgreSQL

    PostgreSQL Client Version 9.2 or higher

    for Amazon Redshift

    Amazon Redshift ODBC provider

    for Microsoft Azure SQL, MySQL, Teradata

    The built-in Microsoft Windows drivers

    for Greenplum

    Greenplum ODBC

    for SAP IQ

    Sybase IQ ODBC provider

    Join our customers' list

    Hundreds of happy customers across the globe rely on Database Compare Suite in their data management operations.

    Database Compare Suite Datasheets

    Still not convinced? Download our Database Compare Suite datasheets to learn more about this ultimate product for database developers and administrators.

    Database Compare Suite Datasheet
    8 February 2019

    DB Best Database Compare Suite is the ultimate solution for database developers, administrators, quality assurance and DevOps engineers for automating their daily routine. Database Com...

    Modernize Your Data Estate Datasheet
    19 February 2019

    Read our Modernize Your Data Estate datasheet to discover the benefits of our free assessment offer. Learn how DB Best can help with your on-premises modernization and cloud migration...

  • Short description

    Database Compare Suite is an easy way to integrate into development and test environments, and it is an ideal fit for cross-platform database development, unit testing, and functional testing. This is the perfect tool for production DBAs supporting multiple databases with similar structures and for creating scripts to synchronize data between source and target tables. It supports homogeneous and heterogeneous databases and tables, columns, and user-defined data types.

    Supported versions:

    • Amazon DynamoDB
    • Amazon Redshift
    • Apache Cassandra 2.1 or later
    • Azure SQL Database
    • Azure Synapse Analytics
    • BigQuery
    • Greenplum 4.3.8.0 or later
    • IBM DB2 for Linux, Unix and Windows (LUW) 9.7 or later
    • MariaDB 5.5 or later
    • Microsoft Access
    • Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019 (all editions)
    • MySQL 5.5.3 or later (Database Compare Suite works with previous versions as well, but some features can be omitted)
    • Netezza 7.2.1.0 or later
    • Oracle 9.2 or later
    • PostgreSQL 9.2 or later (Database Compare Suite works with previous versions as well, but some features can be omitted)
    • SAP ASE 12.5 or later
    • SAP IQ 16 or later
    • Snowflake
    • Teradata 14 or later
    • Vertica 7.0

    20 database platforms supported

    Database Compare Suite allows for comparing data and schema across all supported database platforms.

    • Microsoft SQL Server
    • Azure SQL Database
    • Azure Synapse Analytics
    • Oracle Database
    • PostgreSQL
    • SAP ASE
    • IBM DB2
    • MySQL
    • Amazon Redshift
    • Teradata
    • Greenplum
    • Netezza
    • SAP IQ
    • Vertica
    • Apache Cassandra
    • Amazon DynamoDB
    • Microsoft Access
    • MariaDB
    • BigQuery
    • Snowflake

    We conduct payments only with PayPal to protect you and your investments from illegal use.

    Supported versions Price
    and
    ADD PAIR
    Total $0

    The order is available from the desktop version

  • October 16, 2020 5.4

    Date Version Description
    October 16, 2020 5.4

    July 9, 2020 5.3

    July 9, 2020 5.3
    • Support for BigQuery added.
      Database Compare Suite now supports BigQuery, a serverless and highly scalable cloud data warehouse platform.
    • Added the ability to move all column pairs into sorting key columns list and sort all available column pairs by name at the Sorting key selection operation window.
    • Provided users with connection strings templates, which can be used to connect to all supported database platforms.
    • Enhanced the command-line interface options.
    • Read more on our blog.

    April 7, 2020 5.2

    April 7, 2020 5.2
    • Support for MariaDB added.
      Database Compare Suite now supports MariaDB database platform, a fork of MySQL database platform.
    • Added the support of virtual views for relational databases.
      Database Compare Suite treats virtual views as a special virtual metadata type. These virtual views can be included in data operations alongside regular tables and views.
    • Added the Restart button for all operations, which allows for running the same operation for the same objects after refreshing the data.
    • Read more on our blog.

    November 27, 2019 5.1

    November 27, 2019 5.1
    • Support for Microsoft Access added.
      Database Compare Suite now supports Microsoft Access databases. You can use Database Compare Suite to migrate and compare data between your old Microsoft Access database and a new database platform like Microsoft SQL Server, Azure SQL Database, or whatever you choose as an upgrade destination.
    • Added the ability to use SSL to establish a secure connection to PostgreSQL and MySQL databases.
    • Added the ability to exclude computed columns from data operations.
    • Read more on our blog.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    October 20, 2019 5.0

    October 20, 2019 5.0
    • Added a new matching rules section.
      Now, the first step of all data operations is the matching rules wizard. By default, Database Compare Suite creates the pair for metadata objects with the same type, name, and parameters (for stored procedures and functions). Using the matching rules, the user can change this default behavior and specify the custom rules to build desired pairs.
    • Updated the available data operations options.
      Here you can manage table options, data options (see the particular pages of the manual) and change relevant options for each pair of data objects.
    • Updated the available schema operations options.
      Here you can exclude objects from the comparison and choose properties to ignore during comparison and synchronization operations.
    • Redesigned the sorting key selection dialog. Here you can adjust the sorting keys for data operations.
    • Updated the command-line interface to simplify DevOps operations.
    • Extended the trial period to 14 days.
    • Added the license expiration date.
    • Read more on our blog.

    May 2, 2019 4.14

    May 2, 2019 4.14
    • Support for Amazon DynamoDB added.
      Database Compare Suite now supports a fast and flexible NoSQL database service Amazon DynamoDB. You can use Database Compare Suite to compare data between two supported NoSQL databases (which are Apache Cassandra and Amazon DynamoDB) as well as between a NoSQL database and 14 other SQL-based database platforms. Currently, Database Compare Suite does not support tables with composite partition key because we use the standard .NET provider to access the data.
    • Added the ability to use SSL to establish a secure connection to Microsoft SQL Server and Oracle databases.
    • Provided the ability to work with the SET data type.
    • Added the ability to specify whether the driver can trust the server certificate when connecting to the SQL Server database using TLS.
    • Provided users with the ability to ignore column default values and parameter default values during schema comparison or synchronization operations.
    • Fixed a number of bugs with Apache Cassandra, Microsoft SQL Server, Sybase ASE, and Teradata.
    • Read more on our blog.

    Jan 17, 2019 4.13

    Jan 17, 2019 4.13
    • Support for Apache Cassandra 2.1 or later added.
      Database Compare Suite now supports the free and open-source, distributed, wide column store, NoSQL Apache Cassandra database management system. Database Compare Suite allows for comparing data between two Cassandra databases as well as between the Cassandra database and 14 other SQL-based database platforms. Also, in this release, we added schema comparison operations between two Cassandra databases and between Cassandra and Microsoft SQL Server databases.
    • Added the ability to search objects of the selected type across the metadata trees by name.
    • Provided the option to set the tolerance for data operations. This allows for ignoring the difference between the two decimals.
    • Added the row limit option for data operations. This allows for comparing the specified number of rows from each table.
    • Read more on our blog.

    Feb 21, 2018 4.12

    Feb 21, 2018 4.12
    • Added a SQL code tab in the ‘Schema comparison’ operation window.
      Allows the display of SQL code for source and target objects to simplify line-by-line comparison. This tab provides the ability to display both system characters and exclude multiple spaces or empty lines in converted code and in source code. Also, this tab allows for comparing objects with case sensitivity.
    • Improved Fast Data Comparison operation.
      Added a new option in the Fast Data Comparison operation settings allowing for comparing the row count in the source and target tables. Makes sense for large data sets to check whether all data rows have migrated or not.
    • Added LDAP authentication for Teradata.
    • Added column and parameter mappings.
    • Read more on our blog.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    Sep 05, 2017 4.11

    Sep 05, 2017 4.11
    • Support for Vertica 7.0 or later added.
      Database Compare Suite now supports the cluster-, column-oriented Vertica Analytics Platform that was initially designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.
    • Upgraded the Detailed Data Comparison operation.
      Created a ‘Detailed row comparison’ window to clearly see the data differences in the Detailed Data Comparison operation window. To discover the detailed data differences you need to double-click on the selected data row.
    • Improved the schema comparison and synchronization operation options.
      Now the application allows for excluding flex tables, projections, and text indexes from the operation scope.
    • Read more on our blog.

    July 24, 2017 4.10

    July 24, 2017 4.10
    • Support for Sybase IQ 16 or later added.
      Database Compare Suite now supports a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.
    • Improved the Fast Data Comparison operation.
      The Fast Data Comparison operation now allows for fast processing of the floating-point numbers so that Database Compare Suite will interpret them as fixed-point numbers.
    • Improved the data migration operation.
      Provided an option of treating the empty values as NULL to provide the excellent comparison results for various database platforms.
    • Read more on our blog.

    June 12, 2017 4.9

    June 12, 2017 4.9
    • Support for Azure Synapse Analytics data warehouses added.
      Database Compare Suite now supports highly elastic Azure SQL Data Warehouse applicances.
    • Database connection dialog improved.
      Improved the interface of the database connection dialog. Now, when using the connection string to connect to the database, the Database Compare Suite provides the example of the required connection string in the appropriate format according to the selected database dialect. Simply insert the connection parameters into the provided sample.
    • Updated the data operations options.
      The latest release allows for treating the empty values as NULL to provide the excellent comparison results for various database platforms.
    • Read more on our blog.

    Apr 28, 2017 4.8

    Apr 28, 2017 4.8
    • Support for IBM Netezza 7.2.1 or later added.
      Database Compare Suite now supports IBM Netezza high-performance data warehouse applicances.
    • Improved the Fast Data Comparison operation.
      Improved the support of real numbers and large integers in the Fast Data Comparison operation.
    • Improved interval types support.
      Implemented the full-fledged support of the negative intervals.
    • Read more on our blog.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    Mar 9, 2017 4.7

    Mar 9, 2017 4.7
    • Support for Greenplum 4.3.8.0 or later added.
      Database Compare Suite now supports open-source Greenplum data warehouses, geared toward big data analytics.
    • The installer of the application upgraded.
      Database Compare Suite now requires only the Microsoft .NET Framework 4.6.1. So, there is no need to install .NET Framework 3.5 before installing the Database Compare Suite.
    • Matching page UI improved.
      Minor changes to the user interface of a matching page bring noticeable differences to the usability and dramatically simplify user’s experience.
    • Read more on our blog.

    Jan 27, 2017 4.6

    Jan 27, 2017 4.6
    • Support for Teradata 14 or later added.
      Database Compare Suite now supports Teradata databases, which are commonly used to manage large data warehousing operations.
    • New Fast Data Comparison operation added
      Fast Data Compare operation is designed for comparison of big data volumes. It dramatically improves the performance during data comparison in two tables and helps validate data migration.
    • Read more on our blog.

    Oct 4, 2016 4.5

    Oct 4, 2016 4.5
    • Support for Amazon Redshift added.
      Database Compare Suite now supports Amazon Redshift, which is a fast, fully managed, petabyte-scale data warehouse.
    • Support for SQL Server 2000 added.
      Database Compare Suite now supports SQL Server 2000. This a great timesaver for customers looking forward to upgrading their SQL Server 2000 database servers, Database Compare Suite is the only tool that supports this version of SQL Server on the market.
    • Main screen updated to simplify sending the support request.
      Now you can find the Support button at the top right corner of the main application window.
    • Notification about new product version added.
      When we release a new version of Database Compare Suite, you get a notification in the pop-up window when the application starts.
    • Issue with missing objects during operations with schemas fixed.
      Missing categories of metadata are automatically excluded from schema operations.
    • Read more on our blog.

    Aug 4, 2016 4.4

    Aug 4, 2016 4.4
    • Support for PostgreSQL added.
    • Several issues with ODBC support fixed.
    • Issues with metadata loading for DB2 9.7. fixed
    • Data comparison of interval types for different database platforms enabled.
    • Data migration from Views added.
    • Read more on our blog.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    Apr 28, 2016 4.3

    Apr 28, 2016 4.3
    • Support for MySQL added.
    • Setting Comparison operations for SQL Server databases and servers added.
    • Support for ODBC provider for Sybase databases added.
    • Data operations performance in console mode improved.
    • Support of big numeric values in data operations added.
    • Now there is a possibility to save operation scope in the project.
    • Database Compare Suite doesn’t display the metadata categories that are not supported by at least one of the compared databases in Schema Comparison results. For example, there is no point in displaying Check Constraint category, because it is supported by MySQL database, but is not supported by SQL Server.
    • Read more on our blog.

    Dec 16, 2015 4.2

    Dec 16, 2015 4.2
    • Console scenarios switched to XML format and console features synchronized with GUI version.
    • All data operations parallelized.
    • DB2 modules added to the schema comparison operation.
    • DB2 reference type added to data comparison and schema comparison operations.
    • DB2 UDT added to data comparison and schema comparison operations.
    • Oracle UDT added to data comparison and schema comparison operations.
    • SQL Server assemblies added to the schema comparison operation.
    • Information about the duration of data operations added to the operation result and export file.
    • Rows filtering on the source for the data migration operation enabled.
    • Preferences for data migration operation redeveloped.

    Dec 25, 2014 4.1

    Dec 25, 2014 4.1
    • Support for Oracle packages added.
    • Alignment operation on the metadata tree fixed.
    • Detailed data comparison operation added in the console mode.
    • Specification of operation preferences enabled in the console mode.
    • Support for the default value of the function and stored procedure parameters in the schema comparison operation added.
    • Support for extended properties in the schema comparison operation added.

    Mar 12, 2014 4.0

    Mar 12, 2014 4.0
    • Support for IBM DB2 for Linux, Unix and Windows (LUW) for all operations added.
    • Licensing mechanism changed to make the application more stable and comfortable for users.
    • Comparison of inline SQL for constraints improved.
    • Redundant messages about ignored objects in the operation eliminated.
    • Export of schema comparison result added to CSV file.
    • Support for aggregation functions added.
    • Redundant messages removed from the status bar.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    Oct 11, 2013 3.6

    Oct 11, 2013 3.6
    • The Schema Synchronization operation revised – new UI and business logic.
    • Possibility to match objects in different schemas and one group of schemas with another group added.
    • Ability to specify prefix and suffix to ignore for matching objects added.
    • A hierarchy of result properties refactored and several changes added to the export of operation results.
    • Loading of some imported properties for objects in all supported platforms added.
    • A set of issues with memory leaks fixed.
    • Tested on a new version of Oracle (Oracle 12).

    June 20, 2013 3.5

    June 20, 2013 3.5
    • Option of matching Oracle schema to SQL Server or Sybase databases added.
    • Option of matching UDTs to different types added.
    • A new Data Operation Preference implemented – Exclude LOBs from Data Operations.
    • The new design of the Result page in the Detailed Data Comparison operation. Now it helps you easily identify differences in your data.
    • The new design of the Options page in the Data operations. It makes configuration of Data Operation more usable and comprehensible.
    • A set of issues related to comparison and synchronization of Large Objects fixed.
    • Help section updated to bring new abilities and new design.

    Feb 27, 2013 3.3

    Feb 27, 2013 3.3
    • New Type Maps and Type Mapping functionality. All Type Maps were updated to support new data types and new expertise in this area. Also, we allowed having several mappings for one data type with the ability to prioritize them.
    • Support for User Defined Types (UDT) added. Now the application allows users to identify and view a list of UDTs that are created in a selected database.
    • Ability of LOBs comparing added. Now Data Comparison operation can compare data of all types except UDT. Migration and Synchronization of LOBs will be implemented in the next release.
    • Logic of preferences in the data operations corrected. The Data Synchronization operation uses comparison preferences in the inner logic and does not modify data within synchronization from a source data object to a target data object.
    • Option of specifying a Sort Key for a table or view in the Data Comparison and Data Synchronization operations added. This feature allows users to compare data in views and tables and provide a more powerful tool to subtle adjustment of data sorting in operation.
    • Improved the Help section with additional articles about using preferences in the data operations.

    Dec 24, 2012 3.2

    Dec 24, 2012 3.2
    • Option of excluding unnecessary objects from operation scope added. Users can select only required objects for an operation instead of all objects in the chosen category.
    • Ability to migrate data to Sybase added.
    • New design of Object Matching dialog that makes matching operation simpler and clearer for end users.
    • New design of Connect to Servers dialog and new Project workflow. These changes have eliminated problems that led to floating and difficult-to-reproduce exceptions and unstable application behavior.
    • Problems with loading some objects and their properties in Sybase and Oracle fixed.
    • Several issues in the Licensing functionality fixed.
    • Switching to parameterized queries in Data Synchronization operation finished.

    Comparing and migrating databases just got a lot easier!

    Now you can do this with one powerful and simple suite of tools that every DBA and database developer needs.

    Nov 19, 2012 3.1

    Nov 19, 2012 3.1
    • The application has been migrated to .NET Framework 4.0. It allows to use new UI components to build more flexible and usable GUI.
    • Updated UI control for Metadata tree. New UI control eliminates several issues and makes manipulations with Metadata tree more usable and simple.
    • Updated and improved functionality of Filters and Search.
    • Updated Installer. We have eliminated verification of specific Data Provides for Sybase and Oracle and moved this functionality into operations. In the next release, we are going to implement this check into the connection dialog because it is the best place to validate installed providers and notify a user if any problem occurs.
    • Enhanced functionality of Metadata Loaders. Updated loaders have increased performance and stabilized application behavior.
    • A set of issues fixed in application’s functionality.

    Oct 17, 2012 3.0

    Oct 17, 2012 3.0
    • New core architecture that makes the application much faster and stable. Now the execution of any data or schema operations takes 15-30% less time than previously.
    • More usable operations wizards that allow users to easily and more obviously configure any operations. Appropriate changes were also done in the Command Line functionality that now are more usable for work.
    • More intuitive design of the Help section created.
    • Support for SQL Server 2012 with Sequences and new Data Types added.
    • Support for Rules and Defaults in the Schema Comparison operation for Sybase databases added.
    • Option of executing several operations simoultaneously due to performance and functional issues removed.
    • A set of issues in application functionality fixed.
  • Automate CI/CD

    How can I use Database Compare Suite in our DevOps CI/CD pipeline?

    You can run all key operations using command-line interface in Database Compare Suite.

    You can use scripts to automate the execution of any DevOps tasks, redirecting the command-line output into the file or any other tool. Check out our blog post Automating Data Management Operations with CLI Scripts with Database Compare Suite to learn more.

    Automate Testing

    What does it take to validate data as part of a database migration project?

    You can start with comparing database schemas and then move on to comparing the data. Consider using our exclusive Fast data comparison operation to verify data migration in two large tables.

    Finally, you can execute queries against the selected database objects to verify that they return identical results both on the source and target database platforms.

    executing a query

    CLI Limitations

    Does Database Compare Suite have an API that an application could tie into and listen to it?

    Currently, Database Compare Suite does not have an indication of finishing operations. You may use the command-line version of Database Compare Suite in your processing queue. The CLI application automatically closes after finishing the operation. Your script may wait until the operation is complete to process its results.

    Compare Cloud Databases

    Can I use Database Compare Suite to connect to the databases running in the cloud?

    Absolutely! You can use Database Compare Suite to connect to any of the supported databases, no matter where they are running, both on-premises or in the cloud.

    Compare Database Settings

    The trial version of Database Compare always shows the Settings Operations icon as grey. Is this feature available in the free trial?

    You may use Database Compare Suite to compare server or database settings for two Microsoft SQL Server databases. You cannot use this operation for other database pairs.

    Compare multiple objects

    Can I compare more than one pair of tables at a time? Can I specify a few table pairs and run batch comparison?

    You may select the whole Tables category in both source and target sides and start the Data Comparison operation. The standard Data Comparison operation shows you the pairs of different tables. Afterwards, you may want to click the Details button and execute the Detailed Data Comparison operation for a selected pair. You can run the Detailed Data Comparison operation for only one pair of tables.

    Filtering Data

    Can I selectively migrate data from a table with Database Compare Suite?

    You may migrate data from views or virtual views. In this case, you do not need to create a view object on your database server.

    Installation requirements

    The Database Compare Suite installer roll backed after halfway through. Is this normal? Are there any preliminary steps that I need to do before attempting to install this software?

    One of the reasons is that Database Compare Suite uses cryptographic algorithms and requires FIPS validation.

    To disable this policy, you need to set the following registry value to 0:

    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy] "Enabled"=dword:00000000
    

    You can also disable it in the security policy settings. Go to Control Panel — Administrative Tools — Local Security Policy — Local Policies — Security Options — “System cryptography: Use FIPS compliant algorithms for encryption, hashing and signing”. Change this option to “Disabled”.

    Licensing

    May I use a single license for comparing an unlimited number of databases within the specified pair?

    One Database Compare Suite license allows you to use the product with any number of databases or servers within the specified platforms. For example, you can use your license to compare data in different environments (like development, staging, and production) during the database upgrade or migration project.

    A license key specifies only a pair (or multiple pairs) of supported database platforms. The license does not limit your usage to a single database of the specified pair.

    Licensing

    How many users or computers can use the Database Compare Suite license?

    The Database Compare Suite license key is bound to your computer. This means that you cannot use one license key on several computers.

    However, we do not restrict the number of users that use Database Compare Suite. In addition, you can activate several Database Compare Suite license keys on one computer.

    Licensing

    What does the Database Compare Suite license include?

    You may use your license to execute all operations for a selected pair of database platforms.

    For example, your license key for SQL Server to Oracle pair allows you to use all operations between any pair of SQL Server and Oracle servers. This license does not include homogeneous pairs like SQL Server to SQL Server and Oracle to Oracle. To use Database Compare Suite for homogeneous pairs you need to purchase another license.

    Mapping columns

    We know that some columns in every table (for example time columns) have differences. Is it possible to exclude columns for the comparison?

    Yes, Database Compare Suite allows you to exclude columns from comparison by type (for example, you may exclude LOBs and computed columns from the operation scope). In addition, you can uncheck the columns you want to exclude from comparison manually. The following screenshot shows how you can exclude two columns from comparison.

    database compare suite exclude columns from comparison

    Find more details on how to configure this operation on the data operations options page.

    Mapping Columns

    For Oracle to SQL Server migrations, SSMA generates an extra column for ROWID and a trigger that automatically creates a new value on insert. Can Database Compare Suite ignore this extra column when migrating data?

    Yes, Database Compare Suite ignores this column by default. On the matching step of your data migration operation, Database Compare Suite displays this column as unmatched. This happens because the extra column in your SQL Server database does not have a corresponding pair on the Oracle side. In addition, you can exclude this column manually from the operation scope on the Matching page.

    Mapping datatypes

    I am getting a mapping error when I try to map Microsoft SQL Server DATETIME to MySQL DATETIME(3). Is this mapping correct? Database Compare Suite says there are different data.

    The type mapping influences only the result of a schema comparison operation. When you set up the type mapping you mentioned, the schema comparison operation considers column types DATETIME on the Microsoft SQL Server side and DATETIME(3) on the MySQL side equal.

    The type mapping does not affect data operations.

    Mapping datatypes

    Can I set a tolerance on time values to ignore some minor differences?

    Yes, you can manage the options for date and time datatypes comparison. Learn more about using tolerance and ignoring time zones in data comparison operations from the Database Compare Suite user guide.

    Please note that you may specify these settings for all pairs or for a specific pair of tables.

    Mapping Object Names

    Does Database Compare Suite support the comparison of tables and columns if they have different names?

    Yes, Database Compare Suite allows for comparing tables and columns with different names. However, you need to specify matching rules for these tables and columns manually.

    Mapping Columns

    Can I to exclude certain columns in a table for the detailed data comparison operation in the command-line interface?

    Yes, you can do that using the FilterRule element.

    <Operation name="Schema Comparison" sourceScope="DB_SOURCE.dbo" targetScope="DB_2000.dbo">
    <MatchingRules>
    <FilterRule side="source" metadataObjectType="Table" mode="exactName" action="exclude">lobtypesTable, floatTypesTable</FilterRule>
    </MatchingRules>
    </Operation>
    

    Processing Results

    Can I export the comparison results from Database Compare Suite? Is it be possible to insert the comparison results into a SQL Server or MongoDB database?

    Yes, you can export the result of any comparison operation into an XML or CSV file, depending on operation type. For more details see the item number 10 of the detailed data comparison operation page in the user guide. Database Compare Suite does not provide users with an additional API to process these results because customers use their procedures to collect and analyze results.

    Processing Results

    Can I use the ExecuteSQL result in a comparison in CLI?

    Yes, you may use the ExecuteSQL command to create a view. Then you can perform data comparison operation using this newly created object as one of the compared objects.

    Processing Results

    Where can I see the output of executing a SQL statement using the ExecuteSQL element in the CLI?

    Database Compare Suite does not display the result of executing an SQL statement in the command-line interface.

    On the other hand, you may see the result of the SQL statement execution in the GUI. To do so, right-click on the object, select the Execute New Query from the pop-up menu, enter the SQL statement, press the Execute button, and then switch to the Result tab.

    execute sql statement

    Processing Results

    After one record fails because of unique key constraint violation, all comparison process fails. Is it possible to report to log file and continue the operation to discover other changes?

    Yes, to continue the comparison operation after discovering an error, you need to change the option “Number of allowed errors per operation with data object pair”.

    To do so, open the application settings dialog box and switch to the Operations tab. Specify the number of errors allowed during one comparison operation as shown on the image below.

    Required privileges

    What are the necessary privileges for Database Compare Suite to work with Oracle databases?

    To connect to an Oracle database with Database Compare Suite, the user should have read access to the following system tables and views:

    • nls_database_parameters
    • v$instance
    • sys.all_…

    Required Software

    When I try to compare data in Oracle databases, I get the following message: "The data operation for Oracle is not supported by your Oracle Client(x86) client software. Please install ODAC 11.1.0.6.21 or higher."

    You need to install the x64 version of ODAC on your PC. Please note that x64 applications do not see the x86 version of ODAC. Therefore, you need to install the correct version of ODAC from the official site.

    Required Software

    I have a problem with connecting to an Oracle database. Database Compare Suite displays the following error message: "Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies"

    You must register the .NET assemblies to the Global Assembly Cache (GAC). This error message appears if you have not registered the ‘Oracle.DataAccess’ assembly in CAG. In this case, we recommend to download ODAC and install it. Pay attention to registering Oracle components in CAG (.NET Runtime 4.0).

    You may also register installed components manually, but it may require installed Visual Studio (for example, for using “gacutil.exe”).

    Setting Timeout Values

    In SSMA for MySQL, the parameter “data migration timeout in minutes” is set to 1440 (1 day). Can Database Compare Suite handle migrations that take longer than that?

    Database Compare Suite does not have time limitation for the data migration operation.

    By default, command timeout is infinite. You may change it in the application configuration file.

    Supported platforms

    Does Database Compare Suite support IBM DB2 for z/OS?

    No, you cannot use Database Compare Suite with IBM DB2 for z/OS (mainframe) databases. As described in the product features, Database Compare Suite supports only the LUW version of IBM DB2.

    Supported Platforms

    May I use Database Compare Suite to compare Sybase ASE v11.9.2 and SQL Server 2012 databases?

    No, you cannot use Database Compare Suite with a Sybase ASE v11.9.2 database. As described in the product features, Database Compare Suite supports Sybase ASE starting from version 12.5.

    Synchronize Data

    How can I address data differences discovered by Database Compare Suite?

    You can fix most of the issues directly in the Database Compare Suite. For example, you can migrate data from one table to another or even synchronize data from one table with the values of another table.

    Tracking progress

    How can I see the progress for a certain table during the data migration operation?

    The user interface of Database Compare Suite includes a separate progress bar for each pair of data objects for all operations except the fast data comparison operation. This operation does not include a progress bar because the application executes most of the calculations on the server side. Therefore, Database Compare Suite cannot provide users with any statistic information on the fast data comparison operation.

    For the data migration operation, you may see the progress in the operation results tab as shown on the image below.

    DBCS Operation progress

  • Database Compare Suite 5.0 update brings a new user interface
    14 October 2019

    The latest Database Compare Suite release significantly updates the design of our product. In Database Compare Suite 5.0, we updated the user experience and simplified the user interfa...

    Comparing data in your databases using Database Compare Suite
    13 August 2019

    At DB Best, we believe our Database Compare Suite is the ultimate solution for database developers, administrators, quality assurance, and DevOps engineers to simplify their daily rout...

    Detailed data comparison with Database Compare Suite
    20 August 2019

    We continue our blog post series that cover the key Database Compare Suite features. In our previous blog post, we talked about validating data migration. We discovered that several ta...

    Fast data comparison with Database Compare Suite
    22 August 2019

    We continue our blog post series that cover the key Database Compare Suite features. In our previous blog posts, we talked about validating data migration and discovering exact data di...

    Database Compare Suite update 4.14 brings Amazon DynamoDB support
    2 May 2019

    DB Best announces the release of a new version of an ultimate DBA tool Database Compare Suite. The latest version supports Amazon DynamoDB. This is the second NoSQL database platform s...

    Database Compare Suite update 4.13 brings Apache Cassandra support
    17 January 2019

    We’re happy to announce the latest groundbreaking release of DB Best Database Compare Suite. The new version allows for working both with NoSQL and SQL-based databases, comparing dat...

    Database Compare Suite 4.12 update brings some important improvements
    20 February 2018

    We’re happy to announce the latest release of Database Compare Suite 4.12. This new version brings several important improvements and bug fixes, including: Improved User Interface I...

    Database Compare Suite update 4.11 with Vertica Analytics Platform support
    4 September 2017

    We’re happy to announce the latest release of DB Best Database Compare Suite. The new version marked 4.11 brings support for Vertica Analytics Platform. Learn more about the ultimate...

    Database Compare Suite update 4.10 brings Sybase IQ support
    26 July 2017

    We are happy to announce the latest release of DB Best's in-house tool Database Compare Suite. The new version marked 4.10 brings support for yet another data warehouse platform — Sy...

    Database Compare Suite update 4.9 brings Azure Synapse Analytics support
    14 June 2017

    We’re excited to bring you the latest release of Database Compare Suite. The new version 4.9 features support for Microsoft Azure Synapse Analytics along with some other improvements...

    Database Compare Suite update 4.8 brings Netezza support
    3 May 2017

    We’re excited to bring you the latest release of Database Compare Suite. The new version 4.8 brings support for IBM Netezza versions 7.2.1 and higher along with some other improvemen...

    Introducing Fast Data Comparison in Database Compare Suite version 4.6
    27 January 2017

    Many of us regularly use Database Compare Suite — a tool developed by DB Best — for database migration and upgrade projects. This powerful and handy software solution helps confirm...

    Database Compare Suite 4.5 Released — Amazon Redshift and SQL Server 2000 support
    12 October 2016

    We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their S...

    Optimizing your SQL Server upgrade projects with Database Compare Suite
    20 September 2016

    Often at DB Best as part of our SQL Server 2005 upgrade efforts, a complex upgrade can sometimes take weeks to move into production. During that time, a DBA or application developer ma...

    Database Compare Suite update 4.3 — MySQL support and other features
    6 May 2016

    We’re excited to bring you yet another update of the Database Compare Suite tool which adds several major features such as MySQL database dialect support, ODBC support, settings comp...