How to automate SQL Compare steps

Nehal.Shah

Hi,

One of my build steps involves usage of SQL compare tool.
i.e. After each build i need to do db compare and update live with the latest one.

All other parts of build i have automated using batch files i.e. using Dos commands.
I would like to know, how i can automate my usage of SQL Compare? i.e. is there any command line facility which i can use to automate my SQL compare step?

Thanks
Nehal Shah

David Atkinson

Yes, the 'pro' edition of SQL Compare comes with a command line interface. This is described on our Help pages:

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

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

If you have any trouble with it, please let us know.

Kind regards,

David Atkinson
Red Gate Software

Nehal.Shah

Is this not possible with SQL Compare ???

David Atkinson

Nehal.Shah wrote:

Is this not possible with SQL Compare ???

Yes, it is possible with SQL Compare Pro. I have emailed you directly about this.

Kind regards,

David