SQL Comparison SDK^™

Yes. All our products have been designed to work with the very largest commercial databases.

The latest version is SQL Comparison SDK 7.1.

If you are a new user, you can download the SQL Comparison SDK after filling in a short form. If you are a current customer, you can upgrade to the latest version by choosing Check for updates in the Help menu of the product.

Red Gate's SQL tools work only with Microsoft SQL Server 7 or higher. SQL Backup works with SQL Server 2000 and above.

To find out how much it will cost to upgrade to the latest version, please see our page about upgrading.

This is possible. Please contact us for further information.

This is possible. Please contact us for further information.

Read the full license agreement.

The activation server looks for the XML data in the activation request. HTML formatted emails make it difficult for the activation server to locate the activation request in the message, and when it's not found, the server simply gives up and discards the email. To prevent this, always ensure that activation requests via email are in plain-text format rather than HTML.

Register the database, then create a Work object. Use the ScriptObject method of Work to return a Regions object. This contains a collection of the individual lines of SQL code (regions) used to create the object.

The CompareDatabases method of the Database object accepts an enumeration of options as the final argument. These options are listed in the Comparison SDK Help File under Enumerations->Options. To use more than one option, bitwise 'or' them together. In the C# language, this is a vertical bar (Options enOptions = Options.IgnoreFillFactor | Options.IgnorePermissions), and in VB, this is the word 'Or' (enOptions = IgnoreFillFactor Or IgnorePermissions).

When you use the CompareWith method of the Database object, that returns a Differences collection. When you call the BuildFromDifferences method of the Work object to produce the migration SQL, it will only include the individual differences from the Differences collection that are set to true. To exclude the differences, loop through the differences and set each difference object's Selected property that you want to exclude to 'false'.

Unfortunately, the reports are a component of the User Interface assembly, not the Engine, so you would have to write your own reporting function. For some example code on how to do this, please contact support@red-gate.com.

Create a new SelectionDelegate and point it at a function that will return true or false, indicating whether or not the record will be synchronized. This function will accept a SynchronizationRecord object as the only argument. Pass the SelectionDelegate as the second argument to the GetMigrationSQL method of the SqlProvider object.

When you build a collection of ComparisonSettings to use in the CompareDatabases method of the ComparisonSession, you can specify the unique index to use as the last argument in the construction of a ComparisonSetting.

SQL Data Compare Engine did not find a suitable primary key on the table to use as a comparison key. You may want to include a check for this condition and alert the user that the table may not be compared.

This is done by specifying options on the SqlProvider.Options property from the RedGate.SQLDataCompare.Engine.SqlOptions enumeration.

No. A properly compiled SDK application will never ask for a serial number when distributed to the end-user.

Copy your application and the assemblies it references to the same folder (or the Global Assembly Cache – not recommended). No registration or registry entries are required unless specifically called for by your application.