SCJP, SCJD, SCWCD, SCBCD
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Originally posted by Darya Akbari:
Hence I always have to run SQL to be sure that these new columns are filled with some default values, so that no NULL POINTER EXCEPTION or the like will be thrown
Why not adopt the practice of always specifying a default value for the column
Originally posted by Mike Farnham:
Just out of curiosity what value do you use for date type columns?
SCJP, SCJD, SCWCD, SCBCD
Originally posted by Darya Akbari:
The schema change itself is not the big problem as long as one let an ORM framework like Hibernate's SchemaUpdate tool do the job.
So the real challenge is the creation of migration scripts![]()
![]()
.
If anyone knows about a good book concerning best practice in data migration , please let me know![]()
However as far as I know there is still no such book on the market![]()
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
SCJP, SCJD, SCWCD, SCBCD
Originally posted by Darya Akbari:
On the other hand Scott himself said in another thread that the book is not about migration![]()
We don't cover migrating between database vendors in the book.
<a href="http://www-306.ibm.com/software/rational/bios/ambler.html" target="_blank" rel="nofollow">Scott W. Ambler</a><br />Practice Leader Agile Development, IBM Rational<br /> <br />Now available: <a href="http://www.ambysoft.com/books/refactoringDatabases.html" target="_blank" rel="nofollow">Refactoring Databases: Evolutionary Database Design</a>
SCJP, SCJD, SCWCD, SCBCD
Originally posted by Darya Akbari:
wasn't it you yourself who said, that I should not expect any miracles from the book concerning data migration![]()
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
SCJP, SCJD, SCWCD, SCBCD
Originally posted by Darya Akbari:
So, think of an iterative software process, where you have any one or two weeks adapt your SQL scripts and keep track of all your domain model changes by maintaining the legacy data. How can that be an easy stuff
. And whether easy or not, it's tedious isn't it
![]()
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
SCJP, SCJD, SCWCD, SCBCD
Don't get me started about those stupid light bulbs. |