Options

How to integrate SQL Compare with CVS Source Control

pavel.shiryaevpavel.shiryaev Posts: 2
edited September 4, 2008 9:21AM in SQL Compare Previous Versions
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
· Share on Twitter

Comments

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    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
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.