DMLs and SQL deployment manager + source control

Automated deployment for web applications and databases

DMLs and SQL deployment manager + source control

Postby paraggadkari » Thu Dec 26, 2013 9:03 pm

Is there a way to version control DMLs using the SQL Source Control and deploy them through deployment manager?
paraggadkari
 
Posts: 15
Joined: Tue Nov 05, 2013 3:25 pm
Location: United States

Postby chirayu » Mon Dec 30, 2013 11:34 am

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/displ ... es+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
chirayu
 
Posts: 73
Joined: Mon Sep 17, 2012 5:48 pm

Postby paraggadkari » Fri Jan 17, 2014 4:30 pm

DMLs could be configuration (specific to environment or customer), or migration script. The tables may not be part of the static data.
paraggadkari
 
Posts: 15
Joined: Tue Nov 05, 2013 3:25 pm
Location: United States


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests