I do this all the time with WDDX packets. I expect XML is the modern way. Depending on how well your machines can talk to each other it could be completely automatic.
Douglas Jordon wrote: > > We need to synch a db that drives a web site to the master on our > clients LAN. Because of licensing concerns, the two DB can't talk > directly to each other, and it has been decided that an intermediary is > called for. So I need to: > > 1. Copy a few tables and query another(for all columns except one > containing binary data) to the intermediary DB. > > 2. Send those tables to replace those on the website(the server DB also > contains some tables that will not be updated in this process). > > Since their traffic is very light(maybe a sale or addition a week on > average) eveyone agrees that weekly synchs are sufficient. > > What we've done during the development phase is to take a DUMP file from > their daily backups, restore it on out server, and then use DTS to ship > it up to the server. This works, but we'd like to automate the process. > What's the best and/or easiest way? We're obviously not SQL server gurus > but would like to learn more. > > TIA, > > Doug Jordon > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
