Hi all, here is the situation, a client wants to administer his database offline, and each night synchronize the two databases (online one driving the website, offline one he changes). How can I do it ? I have thought about doing some _really_ funky thing with comma delimited files, he would collect a comma delimited file from the server containing changes that have occured in the online database since the last download (I'll keep a copy of the file he is sent so I can work out which rows have been inserted or modified and create the file appropriatly - don't know how deletion could be done...), he -- some magic happens -- to load the file into ACCESS (it is an access database online too, but tht may change - hence why I need this as DBMS independant as possible) where he changes rows to his hearts content. He then goes and exports & uploads this file to coldfusion which goes through and works out what has changed and performs the appropriate inserts/updates and deletes to do the job - as far as conflict resolution, well, I don't know how that would work I guess just not comitt changes and inform him of where the error occured and what he can do about it. The matter is complicated because the database is going to be getting big and can also be modified online in various ways, otherwise I'd just keep a local copy and update the online copy to reflect it via a CSV file upload of the whole database every night, or even just upload the database via FTP every night. This is a very long-winded and tricky way to solve the problem, there MUST be an easier way to do this. I want to try and steer clear of DBMS particular methods as much as possible (both because this DB will have to be moved to a more powerfull DBMS in the near future and because I would like a solution that I can apply in the future to different DBMS). A system that is as transparent to the user as possible is highly desirable, and a system that wouldn't need new software on the server & client machines would also be desirable (hence my fixation on doing this through ColdFusion itself). Ideas anyone, please ? James Sleeman -- [EMAIL PROTECTED] ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
