Introduction

SQL Delta performs three primary functions, the first is comparing and optionally synchronizing the structure (schema) of two SQL databases, the second is comparing the data in tables (and optionally views) of both the databases and the third is to display the schema of a database. 

SQL Delta can generate update scripts to synchronize one database with other database, for both structure and data.

1) Structure Compare and Synchronize

SQL Delta compares the structures of two SQL databases by locating differences in tables, views, stored procedures and all other database objects. Once compared you are presented with an overview of the objects highlighting different, added or deleted. An update script can be generated to synchronize the source to target and this script can be executed directly from SQL Delta or saved for later execution using another tool.

Schema Compare Project, Schema Compare Results

2) Data Compare

SQL Delta can perform a data compare of one or more tables. The data compare results show an overview of each type of difference, added, missing or different data for each table and displays the actual data for each table highlighting any differences. The data can be synchronized by generating and executing an update script from SQL Delta or saving the script for later execution. 

Data Compare Project, Data Compare Results

3) Reports

SQL Delta provides various structure and comparison reports which are saved as HTML.

4) Command Line Mode - Automating SQL Delta

Command line mode provides a way of running SQL Delta without the need for user intervention. To run in Command Line mode just add the project name to the command line. SQL Delta interprets the project file as a set of commands and can optionally generate a difference script, execute the script, email the script, print reports and perform other functions of SQL Delta.

Supported Database Servers

SQL Delta for SQL Server compares Microsoft SQL Server 2000 through to 2017 and Azure.
SQL Delta for Oracle compares Oracle Database 8+ databases.
SQL Delta for MySQL compares MySQL 5+ databases.

More Information

For the latest information about SQL Delta please visit www.sqldelta.com. For support send an email to support@sqldelta.com or visit http://support.sqldelta.com