How to review the database scripts before deployment?

Automated deployment for web applications and databases

How to review the database scripts before deployment?

Postby enaksanamun » Wed Oct 23, 2013 9:38 am

Hello guys,

I guess the topic says everything about my question. I am a DBA and I'd like to review the database scripts before applying them to the target machines. As far as I can see there's no such an option in the web interface of the DM, however I thought if I knew where those NuGet files are stored, I can manually review the files if that's a possibility?

P.S.
- I use NuGet as the package feed.
- I use the SSMS Snap-in to create packages.

Thanks in advance.

Cheers,
Ekrem
enaksanamun
 
Posts: 2
Joined: Wed Oct 23, 2013 9:32 am

Postby rickjr82 » Wed Oct 23, 2013 1:07 pm

I would also be interested in being able to download a package directly from a link in DM.
rickjr82
 
Posts: 16
Joined: Wed May 22, 2013 3:03 pm

Postby james.billings » Wed Oct 23, 2013 1:52 pm

It somewhat depends on how you've set up your project as to whether you'll be able to see the script or not. There's nothing in the Deployment Manager UI, but you could certainly grab the nuget file from your feed and open it up to have a look using something like Nuget Explorer

However, if you're using Dynamic database packages then there probably won't be anything to see, because the script is generated on the fly during deployment. You can choose to validate the deployment either before or after the upgrade by setting some variables. Please see here for details on deployment validation.
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate

Postby enaksanamun » Thu Oct 24, 2013 2:41 pm

Thanks James. I guess I perform Dynamic updates.

I took a look at the document you suggested, however the thing I was looking for reviewing the SQL Server database scripts before the deployment. I talked to Alex from RedGate support and thanks to him, he informed me that feature is not available for the current release, but will be available with the next release. So I guess I have to wait for the next release to start using this nicely done deployment tool.
enaksanamun
 
Posts: 2
Joined: Wed Oct 23, 2013 9:32 am

Postby justin.caldicott » Thu Oct 24, 2013 4:52 pm

Hi Ekrem,

The ability to review scripts conveniently as part of the release process, including allowing them to require approval, is in our upcoming work. It's not going to be part of the next release (tomorrow), though tomorrows release should include some exciting improvements to database deployments.

We'd love to get your input on the review story if you have the time?

Just send an email to justin.caldicott@red-gate.com and we'll arrange a time.

Best wishes,

Justin
Justin Caldicott
Product Manager - Deployment Manager
Red Gate
justin.caldicott
 
Posts: 55
Joined: Wed Apr 20, 2011 5:42 pm


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests