Needing some help with an idea

gsuttie

I wanna be able to install the toolbelt and basically automate the creation of a sql script with any schema changes and any data changes between 2 databases from our build server - im thinking best bet is to use the comparison sdk, is that the right thinign or better way to do this?

Cheers
Greg

Rob C

Hi Greg,

You could use the SDK - that would certainly be one way you could do it. Alternatively, if you have the Toolbelt then you'll have SQL Compare Pro and SQL Data Compare Pro, which have a command line interface which you can use for automating a comparison and creating of a script. Unless you need to use the SDK, for example if you were building this functionality into an existing .net application, then I would recommend using the command line for simplicity.

If your intention is to try and do some sort of continuous integration/delivery, then have a look at DLM Automation. It works with your existing build server via its Powershell cmdlets or by one of the add-ons we provide for build and release systems.