How to Deploy Source Control DB without SSMS Plugin?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

How to Deploy Source Control DB without SSMS Plugin?

Postby fordc03 » Mon Dec 09, 2013 4:21 pm

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.
fordc03
 
Posts: 39
Joined: Fri Jun 02, 2006 3:38 pm

Postby Evan Moss » Wed Dec 11, 2013 7:44 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

Thanks,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests