Quickly Compare and Safely Synchronize Databases for SQL Server and Oracle Database

SQL Comparison Toolset

Quickly Compare Databases with Robust Comparison Engine

Compare extensive schemas and data between two databases fast while tightly controlling resource utilization with the comparison engine. The comparison engine is robust, highly efficient, easily configurable, and scalable. Synchronize without any technical limitations in the size of the databases.

View Comparison Results

Display a side-by-side, summary of the color-coded results of the comparison to pinpoint at-a-glance similarities and differences between two database objects. The summary includes objects in the source but not in the target and vice versa, identical objects, and the counts of the selected objects. Filter the comparison results based on the object type (such as tables and views) and the status (such as identical and different) of the compared objects.

Filter by Objects

Apply comparison filters to any object including tables, stored procedures, views, user-defined functions, extensible markup language (XML) schema collections, and common language runtime (CLR) assemblies to efficiently manage objects. Specify the name of object types to include or exclude them.

Rerun Comparison with Single Click

Maintain a history of comparison sessions consisting of persisted environments with all of the data related to a comparison operation. This data includes databases and credentials, comparison options, scripting options, execution options, included and excluded object types, and included and excluded individual objects. Repeat a comparison with a single click with these sessions. Control how to sort sessions and the maximum number of persisted sessions with application options.

Take Schema Snapshots

Save snapshots of schemas to maintain an audit trail of schema changes. Compare snapshots and compare snapshots to live databases. Maintain a history and audit trail of schema changes. Reverse schema changes efficiently and safely. Compare schemas with their snapshots, taken immediately before implementing changes. Generate SQL script for reversing schema changes.

Create Project Workspaces

Create and store different workspaces that contain snapshots and comparison sessions for different sets of instances and databases. Easily navigate back to these workspace snapshots to jump straight into a comparison operation.

Save Comparison Sessions

Save all of the settings and configuration options related to a comparison operation (such as databases, credentials, options, mapping rules, scripting options) to re-run of comparison operations with a single mouse click.

Customize Comparison Sessions

Comparing database objects is not straightforward. For example, two tables may be equal when ignoring column collation, but not equal when considering collation. Also, two stored procedures may be equal when ignoring character case, but not equal when considering character case. Further, two indexes may be equal when ignoring the fill factor, but not equal when considering the fill factor. Completely control the comparison engine with more than one hundred exposed comparison options.

Customize Mapping Rules

Customize the way objects of databases are paired together with mapping rules. For example, map renamed objects. Use mapping rules to customize the pairing of schemas, object names, and data types. Determine how schemas map with schema mapping rules. Determine how object names map with name mapping rules. Determine how data types map with data mapping rules.

Create Custom Comparison Keys

Compare tables and views of databases when they are non-compare because of an absent primary key and absent unique indexes. After analyzing the schemas, define a unique key for the comparison. The key consists of any combination of the columns of the table. The rows of the table are paired based on the selected key.

Create Ready-to-deploy Scripts

Generate SQL scripts for synchronization to quickly and easily update the schema of a targeted database. Review the SQL script before executing, save, print, or open it in other tools. Preview the synchronization log for a summary of the changes to be applied to the target database.

Generate Safe Scripts

Ensure that the database changes will either happen in their entirety or not occur at all by wrapping their SQL script into a single transaction with a variable transaction size. Generate this SQL script for database changes based on the results of the database comparison. Organize the SQL scripts in clearly defined sections. The SQL is adequately ordered based on the dependencies between the objects. Properly initialize the set settings. Receive notifications concerning issues (such as data loss) before deployment. Log and handle the errors for every object that is affected by the change.

Run Extensive Scripts

Run successfully extensive SQL scripts for synchronization with the execution engine for SQL script. Such large SQL scripts include SQL scripts for binary columns and large text columns of tables. The execution engine is proprietary and intelligent. Provide continuous information on progress. Interrupt the SQL script safely if needed.

Handle Large Databases

Serialize rows of data and fragments of SQL script as needed with custom-built algorithms. Ensure strict control of the utilization of memory.

Choose from Multiple Connection Options for Oracle Database

For Oracle Database, select from four types of connections: Basic connection, TNS identifier, easy-connect method, and connect descriptor method. Control the connection timeout and other Oracle Database settings with parameters.

Save Time with Intuitive User Interface

Complete comparison and synchronization tasks in the minimum amount of time possible with multiple, intuitive paths in the modern graphical user interface. Access a context-sensitive ribbon, action panels with clear descriptions, context-sensitive menus, asynchronous implementation of lengthy operations, and detailed information on progress. Display the results of comparisons in a well-organized manner in a highly customizable window. Efficiently locate the differences and determine the actions needed to push schema and data changes from one database to the other.

Migrate Across Database Versions

Perform a comparison operation between any of the supported versions and editions of SQL Server including Azure SQL Database and Amazon RDS for SQL Server, and Oracle Database. Compare with the comparison engine the objects that are relevant for both sides of the comparison. Generate synchronization SQL scripts that are specific to and compliance with the version of the target SQL Server and Oracle Database.

Handle Errors Systematically

Eliminate unexpected and unexplained results with the systematic handling of errors. Register and report non-critical errors without interrupting comparison and synchronization operations. Report errors in dialog windows and the output panel. Generate a complete log of errors.

Fully Control Comparison and Synchronization

Exercise granular control over the behavior of the comparison engine with a wide array of options. Compare views and tables. Analyze dependencies of tables. Arrange the SQL script for synchronization accordingly. Compare databases with different collations. Quickly compare and synchronize schemas for entire databases and selected objects, and easily compare and synchronize data for entire databases and selected tables.

Automate and Integrate

Schedule comparison and synchronization operations to run unattended with the command line interface (CLI). The command line utility is highly configurable. Call the command line utility from schedulers such as the Windows Task Scheduler and Oracle Scheduler.

No credit card required! Fully functional for 14 days HeroImage

Buy Now

Includes first year of maintenance.

Add to Cart
Request a Quote

Live product Demo

See SQL Comparison Toolset in action with a seasoned pro.

Request a Demo