Database Compare Suite™
Try 2-day free fully functional trial version
of Database Compare Suite
Comparing two production databases, Doing a migration or upgrade project…
Now you can do this with one powerfull and simple tool that every DBA and database developer needs.
Product Description
Database Compare Suite is a complex solution to simplify schema and data manipulation tasks in both homogeneous and heterogeneous database environments. This simple, but very effective tool can help you perform even the most challenging operations, such as:
Who Can Benefit From It?
To work with this tool you don’t have to be an expert or possess any deep knowledge in database development.
This tool is very user-friendly and can be helpful for Developers, Testers, DBD and DBA
Visit our Support Forum to get more information about this product.
Rob C., CTO, IT Company
Database Compare Suite has saved us months of work. And we did not have to take people off other projects.
Features
Schema comparsion
The application allows you to compare database schemas and identify differences in multiple schema objects such as: Tables, Views, Triggers, Stored Procedures, Functions, Packages, Synonyms, Rules, etc. Schema comparison operation can be performed on any pair of objects or categories. While performing comparison the application takes into account specifics of all supported dialects.
Schema Synchronization
Application helps you to synchronize database schemas when you have two different versions of databases. It can be useful in database migration from one dialect to another. Application generates synchronization script based on Schema Comparison results. You can then use the generated script based on your needs: either execute it while using the application or use only part of it to perform some other operation.
Data Comparison
This feature allows comparing data in databases with equal or close to equal database schemas. The operation can be performed on any pair of databases and does not depend on a dialect. Only 2 objects take part in this operation: Views and Tables. In case one of the compared databases doesn't have such objects, operation will be aborted.
Data Migration and Synchronization
This feature can be used for data manipulations. Each of these operations doesn’t depend on a dialect and can be performed on any pair of databases.
Using Data Migration operation you can simply copy all data from one database to another. To perform this operation the application uses Bulk Copy function, which requires additional software specified in the System Requirements section.
Using Data Synchronization operation you can synchronize data in the target database with data in the source database. This operation does not require any additional software.
Command line and GUI-based version
This feature enables to easily integrate Data Compare Suite into development and test environments and use it on a regular basis in unit, integration and functional testing or for cross platform database development.
System Requirements
Database compare suite requires that the following software is installed on your computer.
Operating system
Windows Server 2003; Windows Server 2008; Windows XP; Windows Vista; Windows 7.
100 MB of available hard disk space.
Additional software
—
Microsoft .NET Framework 4.0
—
Oracle Client Software with Oracle Data Provider for .NET version 9.2 or higher (only for Oracle databases)
—
Sybase ASE OLE DB Provider 12.5 or 15.0 (only for Sybase databases)
Short description
Easy way to integrate into development and test environments. Ideal fit for cross platform database development, unit testing and functional testing. Perfect tool for production DBAs supporting multiple databases with similar structure.Creating scripts to synchronize data between source and target tables. Supports homogeneous and heterogeneous databases. Includes tables, columns, user defined data types.
Database combinations
Schema compare
Data compare
Bundle - 10%
Date
Version
Description
Apr. 9, 2013
3.4.4843
New version of Database Compare Suite contains the following improvements, changes and fixes:
- Added support of LOBs in the Data Migration and Data Synchronization operations. The support of LOBs in the Data Migration operation is limited by provider’s abilities. Data Synchronization operation fully supports LOBs in all dialects.
- Added ability to manage scope of the data operations at the column level. Now the application allows to exclude a single pair of columns from the scope of Data Comparison or Data Synchronization operation.
- Extended user abilities to configure the data operations. Now the application allows to specify preferences for any pair of tables or columns in the scope of Data Comparison or Data Synchronization operation.
- Restored work of Command line. Support of the new features in data operations will be added to Command Line in the future releases.
- Updated Help for changes support in the Data Operations.
Feb.27, 2013
3.3.4804
This version contains the following improvements, enhancements and fixes:
- 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 ability to prioritize them.
- Added support of User Defined Types (UDT). Now the application allows to identify and view a list of UDTs that are created in a selected database.
- Added ability of LOBs comparing. Now Data Comparison operation can compare data of all types except UDT. Migration and Synchronization of LOBs will be implemented in the next release.
- Corrected logic of preferences in the data operations. 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.
- Added ability to specify a Sort Key for a table or view in the Data Comparison and Data Synchronization operations. This feature allows user to compare data in views and tables and provide more powerful tool to subtle adjustment of data sorting in operation.
- Added additional articles to the Help about using preferences in the data operations.
Dec.24, 2012
3.2.4738
This version of Database Compare Suite contains the following updates:
- Added ability to exclude unnecessary objects from operation scope. User can select only required objects for an operation instead of all objects in the chosen category.
- Added ability to migrate data to Sybase.
- New design of Object Matching dialog that makes matching operation more simple and clear for end user.
- New design of Connect to Servers dialog and new Project workflow. These changes have eliminated problems that led to float and difficult to reproduce exceptions and unstable application behavior.
- Fixed problems with loading some objects and their properties in Sybase and Oracle.
- Fixed several issues in the Licensing functionality.
- Finished switching to parameterized queries in Data Synchronization operation.
Nov.19, 2012
3.1.4703
This version contains the following improvements, enhancements and fixes:
- The application has been migrated to .Net Framework 4.0. It allows us 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 in operations. In the next release we are going to implement this check into the connection dialog because it is the best place where we should validate installed providers and notify a user if any problem occurs.
- Enhance functionality of Metadata Loaders. Updated loaders have increased performance and stabilized application behavior.
- Fixed set of issues in application’s functionality.
Oct.17, 2012
3.0.4668
This version of Database Compare Suite contains the following updates:
- New Core Architecture that makes application much faster and stable. Now, execution of any data or schema operations takes on 15-30% less time them previously.
- More usable operations wizards that allow easily and more obviously to configure any of operations. Appropriate changes also were done in the Command Line functionality that now more usable for work.
- New Help design that allows more easily work with it.
- Added supporting of MS SQL Server 2012 with Sequences and new Data Types.
- Added supporting of Rules and Defaults in the Schema Comparison operation for Sybase databases.
- Removed ability to execute several operations at the same time due to performance and functional issues.
- Fixed set of issues in application functionality.
