Red Gate forums :: View topic - DMLs and SQL deployment manager + source control
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

DMLs and SQL deployment manager + source control

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
paraggadkari



Joined: 05 Nov 2013
Posts: 15
Location: United States

PostPosted: Thu Dec 26, 2013 9:03 pm    Post subject: DMLs and SQL deployment manager + source control Reply with quote

Is there a way to version control DMLs using the SQL Source Control and deploy them through deployment manager?
Back to top
View user's profile Send private message
chirayu



Joined: 17 Sep 2012
Posts: 51

PostPosted: Mon Dec 30, 2013 11:34 am    Post subject: Reply with quote

Sorry, what do you mean by DMLs?

If you mean, static data in tables, SQL Source Control does support that.

You will need to generate a package of your database to be able to deploy it through Deployment Manager. The easiest way to generate a package of your database is through Deployment Manager SSMS Add-in. After installing it, you can right click a database in SSMS, follow the steps in the wizard and a package will be published to Deployment Manager. More info: http://documentation.red-gate.com/display/DM2/Creating+and+publishing+database+packages+in+SSMS. You can then deploy the package from Deployment Manager web interface. This is one of the easier ways to start deploying databases with Deployment Manager.

You can of course automate the creation and publishing of database packages.
_________________
Chirayu Shishodiya
Software Engineer - Deployment Manager
Red Gate
Back to top
View user's profile Send private message
paraggadkari



Joined: 05 Nov 2013
Posts: 15
Location: United States

PostPosted: Fri Jan 17, 2014 4:30 pm    Post subject: Reply with quote

DMLs could be configuration (specific to environment or customer), or migration script. The tables may not be part of the static data.
Back to top
View user's profile Send private message
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