A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
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.
- Posts: 39
- Joined: Fri Jun 02, 2006 2:38 pm
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
- Posts: 112
- Joined: Wed Jun 12, 2013 8:56 pm
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 0 guests