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.