How can we help you today? How can we help you today?

SQL Changeset Automation?

I have only limited experience with SQL changeset, but am curious to know how this may help with an AUTOMATED snapshot tool that I wrote to collect binary snapshot files of all CHANGED databases. Its currently running as an AT job, but will eventually run as a service on a server.

I've been wanting to do the same using the SQL script file feature and check these into VSS using automation.

It looks like the limitations of SQL changeset will prevent this functionality? I was hoping for some VSS integration at the automation level.
dwainew
0

Comments

1 comment

Sort by
  • David Atkinson
    I don't see why this shouldn't work in theory.

    1) use the command line version of your source control tool to check out the scripts folder
    2) use the SQL Compare command line to synch from your live database to the checked out working folder
    3) label the scripts folder in source control with your version information
    4)using your source control command line you check the scripts folder back in.

    Is this what you're looking for, or am I misunderstanding your requirements?

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.