Networked Database unavailable so use applications local Database
Posted on 2006-05-27
My question today is to determine if my projects goals are feasible or to find out if I need to backup and punt.
I have been developing a Law Enforcement application that is almost completely database driven and the problem is that once the user looses a connection, the application thus becomes useless. My question is,
(1.)"How or can I make the application use a local "offline" database that resides in the application to collect the data if a connection to the network "online" database is unavailable and secondly, once a network connection is re-established send the local "offline" data to the "online" database? Lastly, if all the before mentioned is possible, once uploading of "offline" data is "synchronized" with the "online" database; delete the contents of the local "offline" database.
I am developing with VB2005 and SQL Server 2005.
Thanks in advance for your assistance.