Includes Schema Compare, Data Compare plus Schema and Data display
Compares the Schema and/or Data within a database. Additionally SQL Delta can display the schema and data just like common database editors.
Supports SQL Server 2000 through to 2016 and Azure
SQL Delta works with all these versions of SQL Server, converting the schema to meet the requirements of the target server.
SQL Delta re-formats the source to match the target when comparing databases on different servers making the display more consistent
and generating less false positives compare results.
Execute multiple projects simultaneously
Run two or more projects side by side in separate tabs, whether it's two schema compare projects on completely separate servers
or a schema compare and data compare project on the same server.
Because each process is run in separate threads you can be reviewing or even running an
update script while waiting for other compare processes to complete.
Project elements shown in Tabs
From editing a project, to displaying the schema compare results and then displaying the schema update script.
Each process is shown in its own tab. The usability of the application is much simpler and consistent.
Even using touch is easier with the new interface.
Generates single synchronize script ready for deployment
SQL Delta now generates a single script including all of the selected objects and in the case of sub-selection can
automatically include dependent objects.
An example of dependent scripting is scripting the change to a single table however that
table has a dependent schema bound view.
SQL Delta automatically includes the alter view (removing the binding) and recreates the binding at the end of the script.
Of course this is all optional but makes for significantly more reliable scripts, in the example without removing the binding
the script would fail.
Run change script from SQL Delta
There is no need to use another tool to run your update script, just click execute within SQL Delta
and the target database is updated.
Of course if you wish you can save the change scripts and use them in other tools,
perhaps you don't have immediate access to the remote server and you're comparing using a snapshot.
Schema Mapping (Object Owners)
SQL Delta has always provided schema or owner mapping allowing you to map an owner from source to a
different owner on the target.
An example of this is you might have configured the database objects to use the default
DBO owner and then you wish to move to a target server that has specific security and the owner TEST must be used.
In SQL Delta all that is required is the source owner DBO be mapped to TEST and the resulting change script will update all of the objects.
Even the contents of a stored procedure will be altered to reflect the ownership change.
One or more filters can be applied to object loading.
An example is where a database has objects that are temporary (all begin with temp_) and not required to be compared.
Simply add a schema filter temp_ and these objects will not be loaded and compared.
The same can be done for columns within a table.
On Completion Events
Each project can execute a series of events once the initial project execution has completed.
The event could be to run another project, save a snapshot of the database schema,
run a report or execute the change script.
On Completion events are an easier way of defining tasks that were available only in command line processing.
Command line processing is still available however now uses On Completion events.
Built-in dependency management
SQL Delta uses both its own analysis of dependent items and the SQL Server dependency data to determine object dependency for scripting.
Dependencies are important to reduce script failures and while these failures may not be catastrophic
(a second compare can be run and the database re-scripted) they do generally prevent a script from running in a single instance.
Perhaps a foreign key must be dropped before other changes are made or a table relies on user defined type that relies on a function.
SQL Delta without the html display is a single executable that less than 20mb.
There are no DLLs and no requirements to register COM, .NET or other services.
Subject to licensing, SQL Delta could be part of an in-house application without the complex installs and other requirements of other tools.
The html display for reports requires some third party DLLS and for MySQL and Oracle there is an option to use provider supplied DLLs.