Fwd: Re: changing database servers
Fwd: Re: changing database servers
- Subject: Fwd: Re: changing database servers
- From: Daniel Beatty <email@hidden>
- Date: Fri, 13 Nov 2009 14:03:10 -0800
Dan Beatty
Ph.D. Student
Computer Science
Texas Tech University
>From: "Daniel Beatty" <email@hidden>
>To: "Tim Worman" <email@hidden>
>Date: November 13, 2009 02:01:32 PM PST
>Subject: Re: changing database servers
>
>Greetings Tim,
>Came close, but I count my blessing I did not have to go that far. In my case, I prepared for that eventuality by having a web service for the outgoing database, another for the new one, and a grid application to copy from one to the other.
>
>This eventuality is difficult to prepare for without question. Of course, OpenBase and MySQL allow for core dumps and imports. Thus if you have access to either one to do that, then that would be the way to go. It is definitely quicker, but in some cases less stable.
>
>Later,
>
>Dan Beatty
>Ph.D. Student
>Computer Science
>Texas Tech University
>
>
>On Friday, November 13, 2009, at 01:54PM, "Tim Worman" <email@hidden> 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?
>>2. Some of the tables/entities that I will be moving to MySQL would hopefully still have relationships to entities in models that refer to the OpenBase database. I've seen this:
>>
>>http://wiki.objectstyle.org/confluence/display/WOL/mail/524483
>>
>>It looks for what I'm looking to do this would probably be OK. Eventually, we may move everything to MySQL so I want to get my ducks in a row now.
>>
>>Tim Worman
>>UCLA GSE&IS
>>
>>
>>
>> _______________________________________________
>>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
>>
>>
>
_______________________________________________
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