Automate SQL compares

uryy4me

I am using SQL Compare 6. Can you do automatic compares with this?

David Atkinson

If you have the Pro edition, you can automate this using the command line:

http://www.red-gate.com/supportcenter/C ... gthecl.htm

Or you can purchase the Comparison SDK to compare programatically.

http://www.red-gate.com/supportcenter/C ... g_page.htm

Kind regards,

David Atkinson
Red Gate Software

uryy4me

Does the command line work in that? The instructions don't show that they work for it?

David Atkinson

Sorry, I'm not sure what you mean by "work in that". Could you explain in more detail what you are trying to achieve?

David Atkinson
Red Gate Software

uryy4me

David,
I had part of the question in the subject earlier.
The link you sent me only showed me examples using SQL compare 7. I want to know if you can use SQL Compare 6 PRO with a command line.

David Atkinson

Yes, all versions of SQL Compare Pro have command line support. From your SQL Compare folder in Program Files type:

sqlcompare.exe /v /? /html > help.html

Open help.html in a web browser and it will provide you with all the options available to you.

Hope this helps,

David Atkinson
Red Gate Software

uryy4me

This is exactly what I was looking for! Thank you David.