Synchronising number of disconnected databases to a central DB
Synchronizing number of disconnected databases to a central DB. here is real scenario: There are number of laptops installed a window application connected with local database and all these machines works in remote area where no internet connectivity is there. we have another web application connected to a central db.the Idea to synchronize database is that every machines export there data at the end of day and save the exported file in removable disk and place all the exported file to a specific location using FTP. My requirement is to import all the exported files into central database and vice-versa. there are around 15 table out of 100 on which need to keep the synchronization. Please suggest.