Hi, I came to know about this group from Martin Fowler's article about "Evolutionary Database Design". I have been looking into this subject lately as I have...
2302
Markus Gallagher
markus_galla...
Jun 2, 2009 4:16 pm
This is exactly how we do our deployments. We develop until feature complete. Then we run a Diff Tool (Visual Studio's Data Dude) to generate our Delta Script....
2303
timander37
Jun 2, 2009 4:17 pm
Hello and welcome. Why are you making this assumption? If you add three columns and then later drop one, it doesn't matter. There is no need for DBA...
2304
Milen Kovachev
milenvk
Jun 2, 2009 6:05 pm
Hello, My experience with evolutionary database development based on incremental scripts is that it is better to actually run the scripts on production exactly...
2305
milenvk
Jun 2, 2009 6:06 pm
Hello, My experience with evolutionary database development based on incremental scripts is that it is better to actually run the scripts on production exactly...
2306
Jens Schauder
jens_schauder
Jun 2, 2009 10:02 pm
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...
