Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Local and remote DB simultaneously

 Post Reply Post Reply
Author
Hilanne Hannu View Drop Down
Member
Member
Avatar

Joined: 11 Aug 2014
Posts: 60
Post Options Post Options   Quote Hilanne Hannu Quote  Post ReplyReply Direct Link To This Post Topic: Local and remote DB simultaneously
    Posted: 11 Aug 2014 at 6:33am
Hi,

I'm considering to use TMS RemoteDB in my new (multitier) application. Some clients would use mobile internet connections to server side. Still system should be very robust and offer offline usage also. 

I'm planning to have MS 2012 SQL Server in Server and SQLite in client. All clients should use primary server database while connection is ok but when client looses internet connect it should automatically use local SQLite. I will synchronize necessary statistic data to clients SQLite DB automatically as background process. After internet connection returns I would need to update inserted info into server side.

I have been thinking to to save data inserted client side simultaneously to both databases MS SQL Server and local SQLite to achieve up to date local DB copy for offline usage. Could I use TMS RemoteDB to implement this kind of use case? Could you give me any guideline or hints how to proceed. 

BR,
Hannu Hilanne



Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2432
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 11 Aug 2014 at 6:57am
Hello Hannu,

RemoteDB is a client dataset to connect to remote server only. You should use RemoteDB to insert data in remote server, and use other option to insert data in local SQLite. 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down