Red Gate forums :: View topic - Database packages and multiple databases
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

Database packages and multiple databases

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



Joined: 01 Feb 2010
Posts: 4

PostPosted: Wed Oct 31, 2012 9:36 am    Post subject: Database packages and multiple databases Reply with quote

Hi

how does database packages work when we have multiple customer databases in single installation which need to be updated?

Does it require creating one package per target database, or is there a chance to specify multiple databases as target for a single DB package and does it (update) happen in a transaction?

We have one web application with multiple customer databases, and we need to ensure they either update in one go, or then not (rolled back in case something goes wrong)
Back to top
View user's profile Send private message
justin.caldicott



Joined: 20 Apr 2011
Posts: 55

PostPosted: Thu Nov 01, 2012 12:55 pm    Post subject: Reply with quote

Hi,

At the moment, the easiest thing to do is to have a package for each of the databases that you want to deploy. You can release them together when more than one has changed, but as you mentioned it's not transactional across databases.

It's a useful bit of feedback, and we'll add it to the board. How do you currently run the upgrades? Do you put the upgrade scripts for each database into one script with a begin/end transaction around it?

Thanks,

Justin
Back to top
View user's profile Send private message
joteke



Joined: 01 Feb 2010
Posts: 4

PostPosted: Fri Nov 02, 2012 2:53 pm    Post subject: Reply with quote

Well currently we run it against all the dbs separately...same script created with Sql Compare however...

we are just to start to evaluate DM and these were just initial questions.

Capability to specify multiple target databases for update as a list in same package would be VERY important feature (for us), we need to ensure that after the installation is done all the dbs are in same state (since web app expects it)
Back to top
View user's profile Send private message
justin.caldicott



Joined: 20 Apr 2011
Posts: 55

PostPosted: Wed Nov 07, 2012 8:56 am    Post subject: Reply with quote

I see, so to you these databases are actually just one component of your software, and thus you'd like them all in the same package?

Having them in separate packages however does allow the ability to update just a single database, and around an updated packge for just one database. Is this something you would need?
_________________
Justin Caldicott
Product Manager - Deployment Manager
Red Gate
Back to top
View user's profile Send private message
joteke



Joined: 01 Feb 2010
Posts: 4

PostPosted: Fri Nov 09, 2012 11:18 am    Post subject: Reply with quote

From schema standpoint there can't be differences in the customer databases of the same site installation. Of course in static data such as settings, there can and most likely is (customer-specific settings) and taht's fine.

Single package or multiple packages, is nuance (except that a installation can have tens of dbs so copying the db packages probably is a tedious task), point is that we need to ensure the upgrade goes smoothly at the installation level (web site plus all databases). If one DB is left behind for some reason, that leads to availability and such issues, and we are in hurry next morning to fix it to the same level with other customer dbs.

That's why we'd need entire site update which happens transactively from web package and one (or multiple) database package point of view. If one of them fails, whole update should be rolled back.
Back to top
View user's profile Send private message
justin.caldicott



Joined: 20 Apr 2011
Posts: 55

PostPosted: Fri Nov 09, 2012 2:58 pm    Post subject: Reply with quote

Great, thanks for the feedback!
_________________
Justin Caldicott
Product Manager - Deployment Manager
Red Gate
Back to top
View user's profile Send private message
dhtucker



Joined: 15 May 2009
Posts: 41
Location: Dallas/FtWorth, Texas

PostPosted: Thu Aug 01, 2013 4:52 am    Post subject: one-to-many database package deployment Reply with quote

Like joteke, I need the same database package deployed to multiple target databases, only instead of tens of databases I'm dealing with thousands of databases (hundreds per server, eight production servers).

Presently I'm using SQL Compare to generate a change script, then running it through SQL Multi Script to execute that script against each target database. This is an error-prone process - the MultiScript target lists must be edited by hand prior to each deployment, and if a target database is out of schema alignment there's no "update" resynchronization available.

(BTW: This suggestion has already been registered on the UserVoice site - please vote it up!)
_________________
Doug Tucker
Software Engineer / DBA
RenWeb School Management Software
Back to top
View user's profile Send private message Send e-mail
justin.caldicott



Joined: 20 Apr 2011
Posts: 55

PostPosted: Mon Aug 05, 2013 3:40 pm    Post subject: Reply with quote

Hi Doug,

Do you typically deploy these databases all at once, or are there different release schedules for different groups?
_________________
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