Continuous Integration elaboration

sqlninja

David,
We are very interested in testing this feature but we need more information on how to include the migration scripts in the TFS build definitions.

Thanks,
John

David Atkinson

It will be a question of invoking the sqlcompare.exe command line from your msbuild script. We will be working on improving our CI document soon (I'll post to this thread when it's ready), but this should get you started for now. Right now, the command line has a limitation that requires your CI server to have a database linked to your source control repository, so it's not perfect just yet. If you have the ability to install SQL Source Control on the CI server, it will be great to get your feedback. If not, you'll need to wait for a later build.

http://downloads.red-gate.com/HelpPDF/C ... LTools.pdf

If you need any help, just post to this thread.

David Atkinson
Product Manager
Red Gate Software