Dear Sir

I have a Central database and 10 client databse that are connected to the central database . All of my data is coming directly to the central database through a telephonic leased line. In any case if connection to central database is not available then data is stored in local server database .

How can i handle the remote database connectivity through a telephonic leased line so that my data is coming directly to headquater and there is no loss of data in between.


How should i transfer the data directly from client database to the server database as soon as the leased line is up?




Pls help me in this regard as soon as possible.
Regards
Saket