SQL Comparison SDK
Automate comparison and synchronization tasks
Compare and synchronize automatically database schemas and data .
The SQL Comparison SDK provides a means to compare and synchronize database schemas and data from within your own applications, with a greater degree of control than the command line interfaces:
- Schedule database comparison and synchronization
- Migrate and deploy schema and data changes
- Build comparison and synchronization functionality into your own applications
- Automate tasks using the new Sequence object type, File Tables, and Columnstore Indexes in SQL Server 2012
Technical requirements
The SQL Comparison SDK is a package of APIs you can use in any IDE designed for .NET development. Using the SDK requires programming experience.
If you want to automate database changes without writing code, you can use the command line interfaces to SQL Compare Pro and SQL Data Compare Pro.
- Windows Vista, Windows 7, Windows 8, Windows Server 2003, or Windows Server 2008
- SQL Server client-side tools
- SQL Server 2005, 2008 or 2008 R2, SQL Server 2012, Amazon RDS, and SQL Azure
- Microsoft .NET Framework 2.0 or later
- MDAC 2.8
- 128 MB RAM
- 200 MB hard disk space
- Runs on a user's PC (can also run on a server)
- Visual Studio, or similar development environment that uses the .NET Framework, if using APIs