• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: changing database servers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >changing database servers (From: Tim Worman <email@hidden>)
 >Re: changing database servers (From: Chuck Hill <email@hidden>)
 >Re: changing database servers (From: Tim Worman <email@hidden>)

  • Prev by Date: Fwd: WO Mini conference in Southern California
  • Next by Date: Re: WOAdaptor did not compile sucessfully on Solaris 10 (using Apache 2.2-64)
  • Previous by thread: Re: changing database servers
  • Next by thread: Re: changing database servers
  • Index(es):
    • Date
    • Thread