Database Compare Suite™

What’s new

Date Version Description
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
  • 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
  • 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 site.
October 24, 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 site.
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 site.
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 site.
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 column and parameter mappings.
  • Read more on our blog.
Sep. 5, 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.
    We 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 you can opt for excluding flex tables, projections, and text indexes from the operation scope.
  • Read more on our site.
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.
  • Upgraded the Fast Data Comparison operation.
    We made the Fast Data Comparison operation even faster! Now you can opt for fast processing of the floating-point numbers so that Database Compare Suite will interpret them as fixed-point numbers.
  • Upgraded the data migration operation.
    Now you can add a table-level lock for the duration of the Data migration operation.
  • Read more on our site.
June 14, 2017 4.9
  • Support for Azure SQL Data Warehouses added.
    Database Compare Suite now supports highly elastic Azure SQL Data Warehouse applicances.
  • Database connection dialog upgraded.
    We improved the interface of the database connection dialog. Now, if you’re 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. So, you just need to insert the connection parameters into the provided sample and you’re ready to go!
  • Updated the data operations options.
    The latest release introduces a very handy option of treating the empty values as NULL to provide the excellent comparison results for various database platforms.
  • Read more on our site.
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 appliances.
  • Upgraded the Fast Data Comparison operation.
    We improved the support of real numbers and large integers in the Fast Data Comparison operation.
  • Improved interval types support.
    We implemented the full-fledged support of the negative intervals.
  • Read more on our blog.
Mar. 9, 2017 4.7
  • Support for Greenplum 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 site.
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 site.
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 orward 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
  • 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 site.
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
  • 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
  • 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
  • Support for IBM DB2 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.
Oct. 11, 2013 3.6.5031
  • 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).
Jun. 20, 2013 3.5.4919
  • 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.4804
  • 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.4738
  • 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.
Nov. 19, 2012 3.1.4703
  • 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.4668
  • 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.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].