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