How to use SQLCompare with web application like .net MVC ?without executing .exe file with process?

gani_one

currently we are executing SQLCompare.exe file by using process and process info or by invoking by using powershell.But we want to use API or SDK if available we didnt get any documentation for the same.We are having web application want to automate so want to integrate SQLCompare in our application.Please let us know drawbacks or any ways of doing it.

Alex B

Hi @gani_one,

The SQL Comparison SDK was retired at v12 and so is no longer available I'm afraid.  To automate using SQLCompare.exe you will need to use the executable provided with SQL Change Automation (default install folder is: C:\Program Files (x86)\Red Gate\SQL Change Automation PowerShell\SC\SQLCompare.exe ).

Information on licensing for automation:
https://documentation.red-gate.com/sc/getting-started/licensing

Information on integrating the command line with your application:
https://documentation.red-gate.com/sc/using-the-command-line/integrating-the-command-line-with-applications

If you are distributing the command line with your own application see this page:
https://documentation.red-gate.com/sc/getting-started/licensing/changes-to-distribution-of-command-line

I hope that helps!

Kind regards,
Alex