VISO database backup
Description:
How to make the VISO database backup?
Solution:
The VISO application itself does not have dedicated tools for making backup copies of the database.
The VISO can export the list of Users (along with groups, cards, pins, etc.) to a CSV file. This can be done via the System menu> Export command.
The method of making the entire database copy depends on the type of base used:
- If the database is Microsoft SQL Server Compact 4.0 type (so-called "file database"):
Go to the directory where the database file with the *.sdf extension is located (the path to the directory can be viewed after hovering over the Database field in the lower left corner of the VISO window), and then copy this file to another location or to an external storage device. The backup is ready. - If the database is the Microsoft SQL Server type (so-called "server database"):
Note: To make a copy of this type of database, use the SQL Server Management Studio tool in the version which matches SQL Server (e.g. 2014).
The method of making and restoring copies is described in the Application note AN017.