Red Gate forums :: View topic - How to Deploy Source Control DB without SSMS Plugin?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

How to Deploy Source Control DB without SSMS Plugin?

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
fordc03



Joined: 02 Jun 2006
Posts: 39

PostPosted: Mon Dec 09, 2013 4:21 pm    Post subject: How to Deploy Source Control DB without SSMS Plugin? Reply with quote

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.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 86

PostPosted: Wed Dec 11, 2013 7:44 pm    Post subject: Reply with quote

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/display/SC10/Switches+used+in+the+command+line

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group