How to Deploy Source Control DB without SSMS Plugin?

fordc03

I'm sure this question has been asked, but let's say I want to take my now versioned database and deploy it to 50 other databases (all with different names)?

Let's also say that the schema varies ever so slightly from the versioned database and I want the deployment to be able to determine what changes need to occur to bring it in sync with the versioned database.

I know I could write a custom utility using the SDK that would do the comparison... but I figured with the tools available there's got to be some way I don't have to do that.

Evan Moss

Thanks for your post.

Unfortunately there's no way to do dynamic deployment like that through the interface.

We've had customers use powershell scripts to call the SQL Compare command line so that they can use variables for database and server names. The command line will have to be called once for each server, though.

You can find a list of switches used in the command line here: http://documentation.red-gate.com/displ ... mmand+line

Thanks,
Evan