• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Automated data exchange between mySQL and MS SQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Prev by Date: Re: www.apple.com/webobjects updated for 5.3
  • Next by Date: Re: Automated data exchange between mySQL and MS SQL
  • Previous by thread: Re: Automated data exchange between mySQL and MS SQL
  • Next by thread: Re: Automated data exchange between mySQL and MS SQL
  • Index(es):
    • Date
    • Thread