To download the sample API projects, click here. There are more than 10 alternatives to Red Gate Sql Compare for Windows, Linux, SQL Server Management Studio and Mac. The SQL Data Compare API provides a number of sample API projects in C# and Visual Basic. Red Gate Sql Compare is described as 'SQL Compare, by Red Gate Software, compares and synchronizes SQL Server databases, automates comparisons, and helps you manage database versioning issues'. For a detailed example, see Worked Example. Add references in your project to, , and .įor details of how you use the API to automate the comparison and synchronization of data, see Comparing and Synchronizing Data Using the API. The easiest way to do this is from within the Visual Studio. You can access the SQL Compare and SQL Data Compare engines from C#, Visual Basic. It provides classes used for comparing and synchronizing the data in SQL Server databases. This is the engine behind SQL Data Compare. To automate SQL Data Compare, you use the following. If you do not have a license, you will be able to use the toolkit for 14 days, but you will not be able to redistribute your applications. To use the SQL Data Compare API, you must have a SQL Toolkit license. NET and you have purchased a Pro version of SQL Data Compare or SQL Toolbelt™, you can use the command line interface.įor more information, visit our Web site at send us an e-mail at visit the Red Gate Software Support Forum.
If you would like to access the tools without programming in. NET or the development environment of your choice. You can reference them from Visual Studio. You can use the API if you are familiar with programming in C#, Visual Basic.
#REDGATE SQL TOOLBELT COMPARING DATABASE MANUAL#
You can use the SQL Data Compare API to synchronize multiple databases, or upgrade your customers' databases without manual intervention. The SQL Toolkit™ provides an Application Program Interface that enables you to automate SQL Data Compare™. Online help and sample projects are provided to help you to use the toolkit. Documentation for version 6.0 is in preparation. Note: This documentation applies to version 5.4 of the SQL Data Compare API.