SQL Comparison SDK without SQL Compare?

[Toan Nguyen]

Hello,

I was just wondering if we can just purchase the SQL Comparison SDK to write our own comparison apps and distribute them to our clients without purchasing the SQL Compare product? Each time we update our main application we would like to run a script to compare and update the client's SQL DB automatically. The idea is to create the latest DB schema, include it in the update, use our own Compare-SQL utility to create the client's DB schema and compare them. Then update the client's DB if there's any changes without manual intervention. Having said that my main questions are:

1. Can we use SQL Comparison SDK to do what I described above? (We have Visual Studio and use C#)
2. If so can we only purchase SQL Comparision SDK or do we have to purchase additional tool and/or license?
3. Can the utilities created with SQL Comparison SDK be distributed royalty-free or do have to get them licensed?

Thank you very much for your time and I'm eagerly awaiting your response.

Toan Nguyen

[David Atkinson]

Hi Toan,

Thanks for your interest.

1. Yes, this is possible. In fact, if you read the "Updating a customer database schema example" blog at http://labs.red-gate.com/index.php/SQL_Comparison_SDK, you will be able to download an example of this very use case.

2 & 3. The license agreement is linked off the main product page: http://www.red-gate.com/products/SQL_Comparison_SDK/index.htm . In summary, it is royalty-free, but if you need to distribute it beyond 100 copies you will need to contact sales@red-gate.com to purchase an increased entitlement.

Kind regards,

David Atkinson
Product Manager
Red Gate Software

[Toan Nguyen]

David,

Thank you very much for your prompt reply. I'm downloading the example you recommended as we speak and I'll report the licensing requirement to my manager. Thanks again.

Toan Nguyen