How can I set up scheduled daily check in

kulmam92kulmam92 Posts: 12
Hi

I'm not sure this is the right tool but I'd like set up daily check in of a DB to SVN. Would you advice me how I can archive this?

Thank you,
Yong

Comments

  • You need the sqlcompare.exe, which is SQL Compare Pro's command line. The steps you need are:

    1) create an svn working folder
    2) run sqlcompare.exe with the following switches

    /db1:yourdb /s1:yourserver /scripts2:yourworkingfolder /sync

    3) run an svn commit

    Use an Agent Job, Windows Scheduler or any other tool that can trigger a batch file periodically. If you plan to install this on a server rather than your desktop, you'll need an Automation License to activate the command line.

    David Atkinson
    Red Gate
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.