I have a client/server application that depends on a vpn connection to a MSSQL Server. Clients are requesting the ability to work offline. I have done some testing with TClientDataset storing information locally, but this will entail rewriting all of my stored procedures and user defined functions into the client.
Does anyone have any experience in this area? Any ideas that will broaden my thoughts on the subject are greatly appreciated.