May be what you can do is setup a mysql -> mysql replication first, then work the EOF copy thing from the replicated database? The really tough thing that you are trying to do is to create a replication without a baseline snapshot…
At some point you will have to take an outage on the production side, otherwise how are you going to switch over to the Postgres DB version of the app? -- Paul Yu Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Monday, February 6, 2012 at 4:33 PM, Ramsey Gurley 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._copyDatabaseDefinedByEOModelAndConnectionDictionaryToDatabaseWithConnectionDictionary, > 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] > > > (mailto:[email protected])) > > > Help/Unsubscribe/Update your Subscription: > > > https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com > > > > > > This email sent to [email protected] (mailto:[email protected]) > > > > > > _______________________________________________ > > Do not post admin requests to the list. They will be ignored. > > Webobjects-dev mailing list ([email protected] > > (mailto:[email protected])) > > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > > > This email sent to [email protected] (mailto:[email protected]) > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected] > (mailto:[email protected])) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > > This email sent to [email protected] (mailto:[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]
