Maybe I am missing something, or there is an elephant in the room: Why is everybody using incremental scripts anyway? We used one script for each migration...
2307
Alexander Karmanov
alexander_ka...
Jun 2, 2009 11:15 pm
The question is how you get these migration scripts and how often you update your environments. Do you build a database and then compare it against the...
2308
alexander_karmanov
alexander_ka...
Jun 2, 2009 11:15 pm
I've experienced the same issues several times. Inncremental scripts save my butt many times: it only cost some time (some ten minutes of half-an-hour total)...
2309
bretweinraub
Jun 2, 2009 11:15 pm
Slightly off topic .... can anyone tell me when and where sequenced and script-based DB migrations originated. Who started it and when? Just curious....
2310
psadalage
Jun 2, 2009 11:27 pm
Hello, Welcome to the group. We usually work with incremental scripts, because these scripts have been tested many (1000's) times through continuous...
2311
hdeiner
Jun 3, 2009 1:25 am
I, too, have faced this problem many times. In fairness, from the "shameless commerce division", let me first state that I developed and teach a course on...
2312
tnabil76
Jun 4, 2009 1:15 pm
Hi, Thank you all for your responses, I didn't really expect that much feedback. I must say I'm overwhelmed by the consensus on the incremental approach, which...
2313
Pramod Sadalage
psadalage
Jun 4, 2009 2:05 pm
For this point. ... fashion. For example, if there was a decision to drop a column and then this decision >>was canceled, there would be a script to drop the...
2314
Pramod Sadalage
psadalage
Jun 4, 2009 2:10 pm
For this point ... correctness of the "roll forward" scripts, it doesn't do the same for the "roll back" >>scripts. If your rollback scripts are not perfect,...
2315
tnabil76
Jun 4, 2009 2:55 pm
I definitely agree that if it was a production system, one would have to keep the data around for a while in some backup table. But are you saying that you...
2316
Devdas Bhagat
devdas.b@...
Jun 4, 2009 2:55 pm
On Wed, Jun 3, 2009 at 5:22 AM, hdeiner <howard.deiner@...> wrote: <snip> ... How does this deal with database replication scenarios? If you are...
2317
Pramod Sadalage
psadalage
Jun 4, 2009 3:11 pm
Pairing with the DBA full time is one of the best steps you can take to reduce problems. Assuming the DBA wants to pair, the team has a DBA, There are lots of...
2318
Nathan Voxland
nvoxland
Jun 4, 2009 5:20 pm
A couple points from how LiquiBase is implemented: With version numbers, you also quickly run into problems with multiple developers and code branches. If you...
2319
Pramod Sadalage
psadalage
Jun 4, 2009 5:23 pm
... Although, theoratically, this would work. It just doesn't make sense to me. It could also be that 6 months later the requirements changed. Going back to ...
2320
raisercostin
Jun 4, 2009 5:56 pm
I find the *maven carbon five plugin* a clean and easy solution for incremental migration of database.http://code.google.com/p/c5-db-migration/ The convention...
2321
milenvk
Jun 5, 2009 4:36 am
... The reason for this is that you are not versioning a statically changed entity like source code, text files, etc. You are rather versioning just certain...
2322
Jens Schauder
jens_schauder
Jun 9, 2009 8:58 pm
... I think there is a conceptual mistake here. The artifact that we are going to deploy is not the complete database, but the change script (either one, which...
2323
Mark Baekdal
mark_baekdal
Jun 10, 2009 7:21 am
It's not often I write here but I thought I'd give it a go. I can only say what I do and for me no single rule fits all - but this is what I'm currently...
2324
tnabil76
Jun 11, 2009 8:04 am
Dear Milen, Could you please name some of your favorite tools which offer those capabilties on Oracle databases?...
2325
tnabil76
Jun 11, 2009 8:04 am
Hi Mark, Thanks for sharing your experience with us. I just have a few points on that appraoch: - If I have understood your approach correctly, then you mainly...
2326
Mark Baekdal
mark_baekdal
Jun 11, 2009 10:49 am
Hi there, I don't like the incremental approach as when I want to know about an object and it's lineage (which often happens) I can see who changed it, when it...
2327
milenvk
Jun 13, 2009 5:14 am
Hi tnabil76, The tool that I am using for Oracle is dbMaintain (http://www.dbmaintain.org). It's relatively new on the incremental tools stage, but it offers a...
2328
jimbrazendale
Jun 13, 2009 5:15 am
Hey Guys, Sorry for not replying sooner to this. This thread is really interesting. Myself, we are currently experiencing real problems in supporting the...
2329
tnabil76
Jun 14, 2009 7:13 am
Thanks Milen....
2330
tnabil76
Jun 15, 2009 3:21 am
Hi Milen, I took a quick look at both tools and I felt that although both are oriented towards an incremental approach, they still represent the two main...
2331
Colin Kabaara
ckabaara
Jun 16, 2009 4:09 am
Take a look at dbdeploy as well if you haven't already. Regards, Colin...
2332
milenvk
Jun 16, 2009 4:09 am
Hey Tarek, I agree with you on all counts here. Hence my coding yet another tool for database development via incremental scripts. By the way, liquibase does...
2333
tnabil76
Jun 22, 2009 3:33 am
Thanks Colin. I found dbdeploy to be quite similar to dbmaintain. I haven't found much documentation, but I assume it's as simple as what's described in the...
2334
jenswm84
Jun 30, 2009 10:22 am
Hi, first of all, this is a interesting thread. I'm doing my bachelor-thesis for such a scenario. I'm actually trying to convince the core dev / dba team, that...
2336
Scott Ambler
scottwambler
Jul 9, 2009 1:52 am
Mike Vizdos and I would like to invite you spend a few moments taking the 2009 Agile Practice Adoption survey at...
