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

remote database synchronisation


  • Subject: remote database synchronisation
  • From: john lennard <email@hidden>
  • Date: Fri, 23 Jul 2004 15:50:01 +1200

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.


  • Follow-Ups:
    • Re: remote database synchronisation
      • From: Hunter Hillegas <email@hidden>
  • Prev by Date: Re: Multiple WOFileUpload Objects?
  • Next by Date: Re: WOMailDelivery: suppress sessionID in links
  • Previous by thread: Re: New Direct Action Class? (SOLVED)
  • Next by thread: Re: remote database synchronisation
  • Index(es):
    • Date
    • Thread