Jim, Personally I hate to rely on user operators to make critical things work, so I would try to get all of the user intervention out of the process and automated.
Add a last update date, time, and location stamp and last sent date & time stamp to the tables you need to keep in sync. You have location 1 and location 2. Write a program that runs in a loop and every few minutes goes and checks for all the updates for that location in the given time frame that have not been sent yet. Update the time & date sent stamps, and unload the records and ftp them off to the other site. Write another routine that watches a given directory for new files. To process the file, you will have all the information you need to load it into the database and do your concurency control checks. Now you need a dedicated machine to run the processes at each end and you will need an FTP site somehere. Set the machines up at each end to continully run looking for, sending, and picking up changes to the system. The hardest thing about doing all of this is dealing with the concurrency control. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 6/03/02 2:16 pm >G-day all > >I was wondering. I want to know how most of ya-all handle >this type of situation. We have a 2 databases we need to >keep in sync (Actually same SCHEMA/db/tables/etc). To do this >we unload the data at one place using the OUTPUT _to filename_ >using the UNLOAD DATA command into a file and then FTP the >file to another location and RUN _the file_ to load it back >into the same database/table structure at the second location. > >What happens is we have two users involved in this process. >One keys in the data, and when she is satsified she prints >a hardcopy, and this marks the data (one column) for the effected >records for them to be sent. Then the first user contacts a more >experienced user who then runs a routine to UNLOAD the data into >files and FTP's them. > >What happens is that the user who is suppose to send them >sometimes goofs, or when second user is gone someone else does >this wrong or ???? and the UNLOAD sequence gets run more than >once creating a file with no records overwriting the first file >before it get's FTP'd. > >I am kinda thinking along the lines of a unique file naming schema, >but this presents a real pain in coding a way to look for what has >been loaded and what has not, and looking for file names or at >least it seems so. I have also wondered about loading and unloading >from different tables and figuring out some kind of tracking method, >but have not done a lot of research in this area yet. > >I was wondering what methods are used by you all with great success? > >Thanks >Jim Limburg > >__________________________________________________ >Do You Yahoo!? >Yahoo! - Official partner of 2002 FIFA World Cup >http://fifaworldcup.yahoo.com >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
