SQL Delta is a database compare tool used to analyze, compare and synchronize database structures and data. SQL Delta compares all database objects including tables, views, stored procedures as well as permissions, user defined functions and so on. SQL Delta will script the differences between two databases allowing you to synchronize the two with the click of a button.
SQL Delta can also perform a data compare between the two selected databases, comparing one or more tables at a time. The combination of schema and data compare allows you to synchronize an entire database at one time with one product. SQL Delta also reports on structures and data including differences and exports reports to HTML and PDF.
Features in the latest version include:
- Command line function, providing users with a mechanism for controlling SQL Delta by remote control, allowing databases to be compared and changes scripted without any user intervention
- Owner mapping: It is now possible to perform comparisons between databases with different users and different ownership configurations
- Star view
- Projects
- Connection manager
- Snapshots and offline comparisons
- Database diagram copying
- Full text catalogs
- Support for case sensitive structure comparisons and data compare improvements