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.