Re: Automated data exchange between mySQL and MS SQL
Re: Automated data exchange between mySQL and MS SQL
- Subject: Re: Automated data exchange between mySQL and MS SQL
- From: "Jonathan 'Wolf' Rentzsch" <email@hidden>
- Date: Wed, 22 Jun 2005 15:45:55 -0500
email@hidden, wrote:
>I have two DBs which I need to have exchange data frequently. One is mySQL
>and the other is MS SQL. I have EOModeled both of them and now have to get
>them to update each others tables.
Based on what little you've written here, this screams bad architecture.
I don't think you really need bidirectional cross-database
synchronization. Instead, you need to choose one datasource (perhaps
coupling it with replication and/or clustering) and run with it.
>My initial thought was to use webservices. I know how to vend them fine
>but
>consuming and placing into a table I don't know. Or since I have EO
>control
>over each there may be a faster, more direct way?
If you're hell-bent on bidirectional synchronization, don't use web
services. It sounds like you're able to connect directly to both
databases simultaneously, so WS only will add overhead and heartache to
your life. Use EOs directly. Or perhaps just raw rows.
| Jonathan 'Wolf' Rentzsch http://rentzsch.com
| Red Shed Software http://redshed.net
| "better" necessarily means "different"
_______________________________________________
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