• 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: remote database synchronisation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: remote database synchronisation


  • Subject: Re: remote database synchronisation
  • From: Hunter Hillegas <email@hidden>
  • Date: Fri, 23 Jul 2004 08:20:46 -0700

No way to standardize platforms between the internal network and the deployment server? MySQL has facilities to do hot-spare, cold-spare, replication, etc...

Depending on volume, the Web Service could be DOG slow.

Does this need to be done in real time?

If you're not using the primary keys for anything, why do you need to get at them at all? Couldn't the remote database create its own keys? Or are you referencing them somewhere?

On Jul 22, 2004, at 8:50 PM, john lennard wrote:

Hello,

I am currently writing a WO application for one of our clients and have run into a slight problem. We need to update a database on the live web server with data from a server that is on the clients internal network.

This is wherein a problem exists. Firstly we cannot connect to their ms-sql server directly due to the high costs of bandwidth an the fact that if their internet connection went down the site would no longer function. With this in mind i thought that i could write an application to transfer the data to the live server, how ever i am not sure of the best approach to take to do this.

I dont want to allow direct connections to the database to allow updating due to the security issues involved, secondly i cannot install wo onto the clients server machine to allow me to use eof and i cannot just do a raw dump of the database as we are running on a mac server with mysql and their internal system is windows with ms-sql so the raw sql will be different.

I was wondering if anybody has encountered this problem before and what approaches they used to solve this or what they would recommend. My first thought was some form of webservice but i am unsure if i can get at the primary key information directly as, of course, it is bad form to allow primary keys to be accessed via eof.

any thoughts on this would be appreciated


thanks

john
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


References: 
 >remote database synchronisation (From: john lennard <email@hidden>)

  • Prev by Date: Re: Firefox and a directAction
  • Next by Date: Re: Firefox and a directAction
  • Previous by thread: remote database synchronisation
  • Next by thread: Question Regarding Session ID's and Cookies
  • Index(es):
    • Date
    • Thread