Re: DB Soft Migration
Re: DB Soft Migration
- Subject: Re: DB Soft Migration
- From: Dan Beatty <email@hidden>
- Date: Mon, 06 Feb 2012 18:26:36 -0800
- Thread-topic: DB Soft Migration
Greetings Ramsey and Ron,
It is definitely worth a test. My recollection of it was not so favorable.
Then again, I was trying it with a really bad schema that should never be
used again.
I have been working this problem for some time. If the scheme is the same
and the scheme is well structured, then the migration should be rather
trival. Therefore, copyDatabase should be able to handle it. If more
horse power is required, then the little ShoeBox migrator I have been
working on may do the trick. It is nearly ready. It is a port of ERRest
to Cocoa with GVC's ERSync and a migration tool. This allows for three
Cocoa apps and two WO apps to sync up (even if translation is required).
The prototype is nearly complete. I hope that it works. I am working on
open sourcing the Cocoa side of it. The WO side is pure Project Wonder,
which is already available.
The bright side is that the port includes an improvement in the form of a
reader and writer for both requests and response to handle the notion of
being both service and client. If completed, I expect it to augment Apple's
iCloud with a plethera of shared WO apps that handle a lot larger spectrum
than 5GB. How valuable this will be, I would not even dare to speculate.
(Just because I made it probably just a light beer, hopefully a good
Guinness).
V/R,
Dan
On 2/6/12 1:33 PM, "Ramsey Gurley" <email@hidden> wrote:
>
> On Feb 6, 2012, at 9:09 AM, Jesse Tayler wrote:
>
>> there was a demo app where you copy data from eomodel-a to eomodel-b and it
>> takes quite a bit of time to churn, but I used that some years ago in such a
>> case.
>
> There's also
> ERXJDBCUtilities._copyDatabaseDefinedByEOModelAndConnectionDictionaryToDatabas
> eWithConnectionDictionary, but I cannot attest to how well it works.
>
>> On Feb 6, 2012, at 3:03 AM, Ron X wrote:
>>
>>> Did anybody do this or maybe know how to do this?:
>>>
>>> I wanna to move from MySQL (not a fork like Percona) to PostgreSQL. But i
>>> can't stop the server.
>
>
> You mean replicate from MySQL to Postgresql on a live server that's still
> running inserts and updates? I've never heard of anything that does that.
>
>
>>> So i think that probably exists possibility to set up the WO or EM to write
>>> data to PostgreSQL, but read data from both of MySQL and PostgreSQL?
>>> And than i will copy all data without locking from MySQL ("in a hot") to
>>> PostgreSQL.
>>> Thank you.
>>> _______________________________________________
>>> 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:
>> com
>>
>> 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:
>
l
>
> 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