SQL Comparison Toolset

Total SQL Compare From Data to Schema

SQL Comparison Toolset

  • Compare and synchronize SQL Server data and schema objects
  • Easy navigation of user interface improves efficiency
  • Automate comparison and synchronization operations
  • Customize schema compare and synchronization sessions
  • Generate ready-to-use database synchronization scripts

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

sqlcomparisontoolset-large
  • Compare and synchronize SQL Server data and schema objects
  • Easy navigation of user interface improves efficiency
  • Automate comparison and synchronization operations
  • Customize schema compare and synchronization sessions
  • Generate ready-to-use database synchronization scripts

Data and Schema Compare

Schema compare provides a quick and easy way for developers and DBAs to compare SQL Server database schemas and propagate schema changes from one environment to another. Data compare functionality allows you to compare and synchronize tables across servers, databases and versions when performing data migrations, copying databases or auditing data.

Navigate the User Interface

A new streamlined and more intuitive user interface includes an improved comparison grid with grouping, filtering and search capabilities, as well as an enhanced script differences view making it faster and easier to navigate within the tool.

Automate via the Command-line

Automate data or schema comparison and synchronization operations using the command-line utility. Command line wizard allows users to create a command line xml file step-by-step, via a simple and intuitive interface.

Customize Comparison Sessions

Add databases, credentials, options, mapping rules, scripting options, and more to allow for flexibility in your comparison operations.

Generate Synchronization Scripts

Generate a synchronization script and view the synchronization log for a summary of the changes that will be applied to the target database.

Schema snapshots

Maintain an audit trail of schema changes by saving schema snapshots. Snapshots can be compared to a live database to identify differences and provide a safe and efficient way to reverse schema changes when necessary.

Customizable comparisons

Easily compare and synchronize data for whole databases or selected tables and quickly compare and synchronize schema for whole databases or selected objects.

Cross-version capabilities

Although comparison and synchronization scripts are version specific, SQL comparison toolset can perform synchronization between any of the different supported SQL Server versions.

Mapping rules

Use mapping rules to customize the way database schemas, object names and data types are paired.

Robust-object capabilities

Use comparison filters against tables, stored procedures, views, user-defined functions, XML schema collections, and CLR assemblies. Choose to include or exclude particular object types by specifying their name.

Project workspaces

Create and store different workspaces for different sets of servers and databases containing snapshots and comparison sessions and easily navigate back to them to jump straight into a comparison operation.

Comparison sessions

Save all the data related to a comparison operation such as databases, credentials, options, mapping rules, scripting options, and more; allowing for single click re-run or comparison operations.

Automate

Automate data or schema comparison and synchronization operations using the command-line utility allowing for unattended comparison and synchronization.

Robust engine

Efficient, fast, configurable and scalable comparison engine.

Ready to deploy scripts

Generate a synchronization script to quickly and easily update the schema of a targeted database. Review the script before executing, save, print, or open it in SQL Server Management Studio (SSMS). Preview the synchronization log for a summary of the changes to be applied to the target database.

Management Console

  • X86 and x64: Windows XP SP3, Windows Server 2003 SP2, Windows 2008, Windows Vista, Windows 7, Windows 2008 R2, Windows 8, Windows server 2012
  • Microsoft .NET 4.0

SQL Server Support

  • SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016