Re: changing database servers
Re: changing database servers
- Subject: Re: changing database servers
- From: John Ours <email@hidden>
- Date: Fri, 13 Nov 2009 23:20:38 -0500
On Nov 13, 2009, at 7:20 PM, Tim Worman wrote:
On Nov 13, 2009, at 3:59 PM, Chuck Hill wrote:
Hi Tim,
On Nov 13, 2009, at 1:54 PM, Tim Worman wrote:
All:
I may be in a situation for one of my apps (maybe more) where we
will be switching database servers. If we did this the change
would involve moving from OpenBase to MySQL. It would also involve
transferring BLOB data. So, I have some questions I want to throw
out related to this:
1. For those that have undertaken a similar task, what method was
used to move the data? a WO-ish method?
This is one way:
http://www.mail-archive.com/email@hidden/msg23024.html
Looks very promising. I may have to give that one a test try
tonight. Thanks much Chuck as always.
When I'm moving from db to db, I usually use the Kettle project from
Pentaho: http://kettle.pentaho.org/
I prefer to have a single, one-step package I can run so my import is
repeatable. As you go through this you'll have to do the conversion
several times at least...for development, QA, and the final production
conversion...and maybe more if things don't go well.
I've never done OpenBase to MySQL, but you usually also find some
incompatible types (like dates, bits, currency, etc) that need special
attention.
John
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden