Red Gate forums :: View topic - Can Deployment Manager perform a selective upgrade?
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

Can Deployment Manager perform a selective upgrade?

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



Joined: 14 Aug 2006
Posts: 32

PostPosted: Wed Nov 13, 2013 1:33 pm    Post subject: Can Deployment Manager perform a selective upgrade? Reply with quote

Just wondering if this has been suggested/thought of.

eg:
1. Using TFS, 100 database items are marked "Ready for Test"
2. Deployment Manager creates release and deploys to test database server
3. Testers pass 90 of those items
4. Can we then "release" those 90 items to UAT database server?


Cheers
Phil
Back to top
View user's profile Send private message
james.billings



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

PostPosted: Mon Nov 18, 2013 2:00 pm    Post subject: Reply with quote

Hi,
I can't think of an easy way this could be achieved really- assuming you're talking either about a set of scripts or a database, our tools work on comparing the state of the DB at that point. The only way you can really select specific objects is through the use of filters, but these are configured from within either SQL Compare or SQL Source Control and we don't have any hooks into however things get marked in TFS as passed (or not).
You could manually set up your filters within Compare, but I'm guessing you wanted something more automatic?
Back to top
View user's profile Send private message
philcart



Joined: 14 Aug 2006
Posts: 32

PostPosted: Wed Dec 04, 2013 2:47 am    Post subject: Reply with quote

Thanks James

What I'm looking for is some way for Deployment Manager to take a bunch of scripts that are in a folder and deploy them to the target database server, bearing in mind that the files in the folder do not represent all objects in the database.

We have regular 6 week releases as well as many "hotfix" releases. The content of the "hotfix" releases vary from a single proc change to new tables, procs and data inserts.

We currently have a process that checks the status of a TFS workitem and downloads the relevant files to a folder. It then builds a long and cumbersome SQLCompare command line to compare those specific objects and generate a change script to deploy. Once the deploy is complete it updates the status in TFS.

Where this process falls down is when there are many files associated with the workitem, or we have many workitems to deploy as part of a larger release.


Cheers
Phil
Back to top
View user's profile Send private message
james.billings



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

PostPosted: Wed Dec 04, 2013 1:29 pm    Post subject: Reply with quote

If you just want to deploy arbitrary scripts, such as the hotfixes, it'll probably require you to package them up along with some custom powershell script (which could use SQLCMD to execute them) using RGPublish (the command line tool).

To use the database package functionality, you'd really need to look at applying the hotfixes to some sort of staging database / source control repo, and packaging the whole DB up - then at deployment time, the SQL Compare functionality DM runs would work out the differences (which, if you're keeping staging up to date with the production copy) should just be the hotfix that needs to be applied.
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