I assume you will have 2 locations where people are entering data to a server at each location and you want the data to be duplicated on both servers. If this is the case you could look at a number of options.
A. You could use publish and subscribe, but this will require all the data to be updated at one server. B. You can use triggers on files to pick up writes which runs a process to copy the data to the other server. (You have to consider data integrity if you are updating the same record on 2 machines at the same time only one version may be saved) - To ensure data integrity I would look at using Message queue (IBM MQ) in ver 10.1 (this will ensure if the communication line or a server went down, then the message queue will hold the updates until the systems are backup and then update.) You could write a UniObject interface and take advantage of Microsoft Message Queue -Another option is to use ODBC inbuilt into UniVerse. You connect to the remote database and do sql writes to it or update through a remote procedure call. Hope this gives you some ideas to explore Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 28 July 2004 8:10 PM To: [EMAIL PROTECTED] Subject: [U2] Copying data between two Universe servers I am looking for the best way to copy data between two Windows 2000 servers running Universe 10.0.10 over a VPN. I was looking at putting the data in a type 1 file and using a ftp copy command running on the scheduler. I don't want all the data being entered on one server I don't know if there is a better way using q-pointers and copying or any other method I haven't thought of yet. Many thanks ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
