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 protected]> 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 protected]) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com >>> >>> This email sent to [email protected] >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth. >> com >> >> This email sent to [email protected] > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/daniel.beatty%40navy.mi> l > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
