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

Support varies by product family, product version, and database engine. See Supported Versions and Editions for the current first-pass matrix, including entries marked * where older support is still being reconstructed from release notes and product history.

SQL Delta for SQL Server remains the primary path for SQL Server schema compare, data compare, schema view, and scripting work. SQL DXP Premium adds cross-platform compare for SQL Server, Oracle, MySQL, and MariaDB, but support and readiness differ by engine and release.

More Information

For the latest information about SQL Delta and SQL DXP please visit https://sqldelta.com. For product support send an email to support@sqldelta.com or visit https://support.sqldelta.com.