SQL Delta vs SQL DXP
SQL Delta
sqldelta.comSQL DXP
sqldelta.comSide by side
| Figure | SQL Delta | SQL DXP |
|---|---|---|
| Price from | — | — |
| Free plan | — | — |
| Free trial | Yes | Yes |
| Open source | — | — |
| Windows | Yes | Yes |
| Plans published | 10 | 0 |
| Spec score · Database Schema Comparison Tools | 8.1 (#6) | 7.1 (#16) |
| Automation | Projects support completion events and command-line execution, including options to generate and deploy sync scripts automatically. | Projects support completion events and command-line runs, including options for quiet mode and automatic script deployment. |
| Data compare | Data Compare identifies row-level differences between environments before data changes move forward. | Data comparison can automatically find tables with primary keys and matching column names, or let users choose tables, index columns, and columns to compare. |
| Data comparison | Data Compare checks row-level differences between environments before data changes move forward. | Data Compare matches rows using one or more index columns, usually a primary key, and checks columns for differences. |
| Maker | The product site credits The Australian Software Company; its company site identifies SQL Delta and SQL DXP as database comparison tools. | The Australian Software Company says it has been in business since 1991 and lists its business address in Sydney, Australia. |
| Privacy and security | The privacy policy says TASC uses firewalls, encryption, and physical access controls to protect personal information submitted to the site. | The maker's privacy policy says it uses firewalls, encryption, and physical access controls to protect personal information supplied to the site. |
| Purpose | SQL Delta compares database schemas and data so teams can review drift and synchronize changes before deployment. | SQL DXP compares databases of the same or different server types and transfers schema or data between SQL Server, Oracle, or MySQL. |
| Reports and snapshots | The product can save HTML comparison reports and XML schema snapshots for release reviews and recovery work. | SQL DXP generates HTML comparison reports and XML schema snapshots that can be stored with version control or used for snapshot comparisons. |
| Schema compare | Schema Compare shows structural differences, can compare live databases with snapshots, and can generate deployment scripts. | It shows objects that differ or are missing on either side and can generate a deployment script to apply changes to the target. |
| Support | Customers can contact the company by email for SQL Delta support and access its support portal. | The company lists a direct email contact for SQL Delta support questions. |
| Trial | The latest full product download can be evaluated for 14 days before a registration code is needed. | The product download is the latest full version and can be evaluated for 14 days without a purchased license. |
Plans
SQL Delta
- SQL Delta for MySQL — Single license$185, paid once
- SQL Delta for Oracle — Single license$370, paid once
- SQL Delta for SQL Server — Single license$370, paid once
- SQL Delta for MySQL — 5 Licenses$510, paid once
- SQL Delta for MySQL — 10 Licenses$920, paid once
- SQL Delta for Oracle — 5 Licenses$1,020, paid once
- SQL Delta for SQL Server — 5 Licenses$1,020, paid once
- SQL Delta for MySQL — Site License$1,395, paid once
- SQL Delta for SQL Server — 10 Licenses$1,850, paid once
- SQL Delta for SQL Server — Site License$2,775, paid once
In their own words
SQL Delta
SQL Delta is a Windows tool for comparing database schemas and data before changes reach production. SQL Delta 7 compares source and target databases that use the same server type; SQL DXP is intended for comparisons across different server types. Schema Compare shows structural differences in live databases or snapshots and lets users select what to include in a deployment script. Data Compare identifies row-level differences between environments. Users can review and edit synchronization scripts before executing them against a target, and projects can add custom script to deployment scripts. SQL Delta can save HTML reports and XML snapshots for release reviews or recovery work. Project completion events and command-line execution support automated runs. Editions are listed for SQL Server, MySQL, Oracle, and PostgreSQL. A separate Read Only Edition allows comparison and script generation but prevents direct script execution. The latest full product download has a 14-day trial. The MySQL single-license plan is $185 as a one-time purchase and includes a two-year software update subscription; purchase terms also describe a perpetual license.