How to integrate SQL Compare with CVS Source Control

pavel.shiryaev

Hi,
We're using CVS for versioning. How can I integrate SQL Compare with it?
Ideally, I'm looking for scheduling SQL Compare to run weekly and commit all updates to CVS in order to enable versioning and DR.
Thank you,
Pavel

David Atkinson

CSV uses an edit-merge-commit source control methodology, so it would be simply a question of using the SQL Compare Pro command line to synchronize your database to a Scripts Folder. Once this has been done, simply use the CVS command line to commit to source control. I've not used CVS myself, but I can't see why this shouldn't work.

When you get this going, it would be great if you could post the necessary command line syntax to this forum post so other users can benefit!

The SQL Compare bit should look like this:
sqlcompare.exe /database1:<your database> /server1:<your sql server> /scripts2:<your scripts folder> /synchronize

You can find help on the SQL Compare command line at: http://www.red-gate.com/supportcenter/C ... 356444.htm

Kind regards,

David Atkinson
Product Manager
Red Gate Software