I meant to say non-vendor specific, rather than "version agnostic". I'm not sure where that came from....
2599
Luiz Esmiralha
lesmiralha
Aug 25, 2010 5:52 pm
Show us the code? 2010/8/24 emanuelbulic <emanuelbulic@...> ... [Non-text portions of this message have been removed]...
2600
timander37
Aug 25, 2010 6:18 pm
We have a solution for database schema versioning, though I'm not sure how well it supports branching. Is the branching for separate production databases or...
2601
psadalage
Aug 25, 2010 6:21 pm
Hello, I'm looking for technical reviewers for a book in the works about Agile Development Practices for the DBA and Data developers. If you are interested,...
2602
Milen Kovachev
milenvk
Aug 25, 2010 6:52 pm
Check out the following: - DbMaintain: http://www.dbmaintain.org/ - works real well with incremental scripts and repeatable scripts. Targets Oracle and other ...
2603
Vasco Figueira
vasco.figueira@...
Aug 25, 2010 7:08 pm
+1 to Liquibase here. Use it on all projects now. ... -- Vasco Figueira Consultor Especialista Java KnowledgeWorks - Consultoria em Sistemas de Informação ...
2604
emanuelbulic
Aug 25, 2010 7:09 pm
I've used a similar solution in the past. It works but it got very messy. We had to dedicate one person to handle all scripts from all developer. No one...
2605
Wil Moore III
digitallysmooth
Aug 25, 2010 7:40 pm
+1 to Liquibase here as well. Using it with MySQL. On Wed, Aug 25, 2010 at 13:03, Vasco Figueira < ... [Non-text portions of this message have been removed]...
2606
Milen Kovachev
milenvk
Aug 25, 2010 7:40 pm
Having multiple versions of each object and running them in different order depending on which one failed, or not, sounds like deviating from the repeatability...
2607
Sebastiano Pilla
etechweb
Aug 25, 2010 8:00 pm
I use DbDeploy http://dbdeploy.com/ and I'm happy with it (using it with PostgreSQL and Oracle). I'll take a look at the other tools mentioned. ...
2608
emanuelbulic
Aug 26, 2010 3:35 am
That's not what I meant; you're certainly right. I meant that should table A fail to upgrade from version 1.1 to 1.2 (UPDATE statement fails due to a FK...
2609
Gabriel Tanase
datamodeller
Aug 26, 2010 11:55 am
Dear Sir, I would be very interested in contributing as a reviewer for this book. You can check my professional profile at: ...
2610
timander37
Aug 26, 2010 1:59 pm
We handle this a little bit differently. If any SQL change script fails, the database is rolled back and the upgrade is postponed. Each SQL change script...
2611
emanuelbulic
Aug 26, 2010 2:22 pm
This approach doesn't work for me. Numbered scripts? I have 10000 of them. What happens when you have 20 developers, and they all need scripts? You must...
2612
Alexander Karmanov
alexander_ka...
Aug 26, 2010 3:06 pm
Numbered script does not mean the script files must be numbered. I use a config file referring to them. Scripts are stored in folders according to their...
2613
Milen Kovachev
milenvk
Aug 26, 2010 3:31 pm
We have successfully used the numbered script approach with multiple developers working simultaneously on the same database. We used DbMaintain for deployment....
2614
Milen Kovachev
milenvk
Aug 26, 2010 3:48 pm
I also forgot to mention that programmables are kept in the so called "repeatable" scripts folder, where we keep one script per programmable and all the...
2615
pablo szittyay
pablo.szittyay
Aug 26, 2010 6:13 pm
i have implemented a custom tool to help me update the database (oracle should work on any database). I use svn to store the database code. What it simply does...
2616
Emanuel Bulic
emanuelbulic
Aug 26, 2010 7:05 pm
What if you move a column and you must also move some data with it. I haven't really seen any complete solutions on the market so far. Sounds like I must...
2617
Milen Kovachev
milenvk
Aug 26, 2010 7:38 pm
Hi Emanuel, I am still curious as to why incremental/repeatable script solution like the one being offered by so many tools would not work for you. It would...
2618
Emanuel Bulic
emanuelbulic
Aug 27, 2010 12:59 am
Actually, I believe I left out a very important requirement, and I apologize.. I also need to deploy upgrades to the field databases that contain only a subset...
2619
pablo szittyay
pablo.szittyay
Aug 27, 2010 12:59 am
I think i may no have explained myself corretly: I have the following folder structure in svn: svn/trunk/src/ [SCHEMA] /TABLE /VIEWS /PACKAGES /TRIGGERS ...
2620
w-p
toetah2000
Aug 27, 2010 8:37 am
My way of getting all databases up-to-date is a variation of the "each change has its own script" way. Instead, I write the whole definition and upgrade in a...
2621
Gabriel Tanase
datamodeller
Aug 27, 2010 1:06 pm
Hi all, Looks to me like this explanation warrants a change in the thread's subject, so that we know exactly what we are talking about. In summary, Emanuel...
2622
Milen Kovachev
milenvk
Aug 27, 2010 1:06 pm
Hi Emanuel, Even this requirement is easily met by incremental/repeatable scripts solution. Consider the "qualifier inclusion/exclusion" feature of DbMaintain ...
2623
Vasco Figueira
vasco.figueira@...
Aug 27, 2010 1:06 pm
At first site looks like Liquibase contexts feature would take care of that. Each changeset is marked with zero or more contexts. Each run specifies zero or...
2624
timander37
Aug 27, 2010 1:06 pm
Emanuel, That sounds like a real mess. I see two options to get out of that situation towards something more maintainable. 1. Keep all of the databases in the...
2625
Emanuel Bulic
emanuelbulic
Aug 27, 2010 1:06 pm
Sorry, I will not be tinkering with thousands of sql files in svn. And for every ALTER TABLE I must modify 2 files, and keep track of which script goes in...
2626
pablo szittyay
pablo.szittyay
Aug 27, 2010 1:06 pm
I undestand your point of view. So let me answer in order what would i do, and by no means this is the correct aproach. 1) Having different database code,...
2627
pablo szittyay
pablo.szittyay
Aug 28, 2010 1:02 pm
But no matter the aproach you will end up with 2 scripts, one for cretion and other for incremental modification. Unless you find a way to make some of them...
