Manage data and schema changes in SQL
- 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
The IDERA SQL Comparison Toolset provides many different tools to diagnose, administer, and analyze SQL Server instances across your enterprise.
When you need to quickly identify and synchronize data and object changes, you can use IDERA SQL Comparison Toolset to:
- Perform SQL Data Compare and SQL Schema Compare tasks and synchronization
- Capture schema snapshots to preserve change history
- Synchronize SQL data automatically via command-line
- Customize your environment using workspaces and saved comparison options
What is IDERA SQL Comparison Toolset?
Data schema and data comparison is sometimes an extremely time consuming and confusing task when completed manually, and the process can be prone to error. Rather than spending hours digging through and scrutinizing data and the overall database structure, then manually generating scripts, wouldn’t it be much easier if there was a tool to automate this process?
IDERA SQL Comparison Toolset provides an easy, automated way to compare schema and data, generate synchronization scripts, and deploy those scripts to synchronize databases. Whether migrating changes from test to production or repairing unwanted changes, IDERA SQL Comparison Toolset saves you time and reduce the headaches of performing manual database comparisons mistakenly applied and unwanted changes.
SQL Comparison Toolset (for Microsoft SQL Server)
Desktop Console
- Microsoft Windows: XP SP3, Server 2003 SP2, Server 2003 R2, 2008, Vista, 7, 2008 R2, 8, 8.1, Server 2012, Server 2016; 64-bit, 32-bit
- Microsoft .NET Framework: 3.0
Database Support
- Microsoft SQL Server: 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017
- Microsoft Azure SQL Database
- Amazon Relational Database Service (RDS) for SQL Server
SQL Comparison Toolset does not install any components, dynamic link libraries, SQL scripts, stored procedures, and tables on the instances of SQL Server.
Cloud
SQL Comparison Toolset runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2). It supports Microsoft Azure SQL Database and Amazon RDS for SQL Server.
Comparison Toolset for Oracle Database
Desktop Console
- Microsoft Windows: XP SP3, Server 2003 SP2, Server 2003 R2, 2008, Vista, 7, 2008 R2, 8, 8.1, Server 2012, Server 2016; 64-bit, 32-bit
- Microsoft .NET Framework: 3.0
Database Support
- Oracle Database: 9i, 10g, 11g, 12c
Comparison Toolset for Oracle Database does not install any components, dynamic link libraries, SQL scripts, stored procedures, and tables on the instances of Oracle Database.
Cloud
Comparison Toolset for Oracle Database runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Oracle Database instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).