SQL Changeset Automation?

dwainew

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.

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