SQL Toolkit™
Latest version: 6.1.0
Automates comparison and synchronization tasks
- Full API access to Red Gate comparison tools
- Incorporate comparison and synchronization functionality into your applications
- Automate tasks using all the new objects, XML datatypes and CLR assemblies in SQL Server 2005
- Schedule any of the tasks you require from the SQL Bundle of tools
The SQL Toolkit (also known as the SQL Comparison and Synchronization Toolkit™) provides a means to programmatically compare and synchronize database schemas and data, either as a standalone scheduled task, or as part of a bigger application.
Walk-through
View our short screen-by-screen introductory walk-through
Demo video
Step-by-step demo of SQL Toolkit in action
It does this by giving you access to the APIs used within our SQL database comparison and synchronization tools. By accessing these, you can completely automate all your SQL comparison, synchronization, packaging and update jobs.
You can, for example, create a program to schedule the comparison and synchronization of your SQL databases; then automate their installation, replication and verification.
The SQL Toolkit also gives you programmable access to the advanced functions of both SQL Compare Pro and SQL Data Compare Pro, including:
- Comparing a live database to a folder of SQL scripts
- Simpler source control management with the SQL Changeset add-in
- Installing a new database directly from script files
- Comparing backups as if they are live databases
- Row Level Restore from a backup to a production or test database
By using the SQL Toolkit you can incorporate all of the Red Gate SQL database tools' functionality into the applications that you create.
An example application using SQL Toolkit APIs
NB: For access to the command line utilities when automating tasks with Red Gate comparison tools, Professional Editions of SQL Compare, SQL Data Compare and SQL Packager are also available.
