remote database synchronisation
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.