SQL server offline mode
I think this is a great feature but I would like to know more about how it works. How is the connection data kept offline when away from the SQL server? Also, is this feature something new to 5.7.3 or was it also in 5.6.3?
All Comments (4)
Hi,
This feature was available in the version 5.6. When it's enabled in the data source, the application keed a encrypted cached version of the database. When the application detect that the connection is unavailable, RDM load the data from the cache. Of course the session can't be edited.
David Hervieux
Even thought the cached copy is encrypted and read only can it be stolen and read by another instance of the application on another computer?
If the application can decrypt the cached copy what is stopping another instance from reading it?
Hi,
The information is saved in document and settings folder and it encrypted with the ntfs security. You must be logged in the account to copy the file. In the next version, we will add another security protection. If the offline data is really sensitive, you can disable it for some users.
David Hervieux
Fair enough. Thank you for your response.