Red Gate forums :: View topic - How to review the database scripts before deployment?
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

How to review the database scripts before deployment?

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



Joined: 23 Oct 2013
Posts: 2

PostPosted: Wed Oct 23, 2013 9:38 am    Post subject: How to review the database scripts before deployment? Reply with quote

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



Joined: 22 May 2013
Posts: 14

PostPosted: Wed Oct 23, 2013 1:07 pm    Post subject: Reply with quote

I would also be interested in being able to download a package directly from a link in DM.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Oct 23, 2013 1:52 pm    Post subject: Reply with quote

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



Joined: 23 Oct 2013
Posts: 2

PostPosted: Thu Oct 24, 2013 2:41 pm    Post subject: Reply with quote

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



Joined: 20 Apr 2011
Posts: 55

PostPosted: Thu Oct 24, 2013 4:52 pm    Post subject: Reply with quote

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
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