StaffMap project databases hold all the information necessary for floors, desks and other assets, staff, reports, security groups, etc. that make up the project.
Note - Only make changes to StaffMap project databases if you are familiar with working in web application databases already. Modifications to the database are not technically supported.
StaffMap uses SQL Server Compact 4.0 databases. These file-based databases can be accessed by a number of different programs but we recommend using Microsoft Visual Studio.
5. In the Database Explorer, click on the 'Connect to Database' button (plug icon).
6. In the 'Add Connection' window, set 'Data Source' to Microsoft SQL Server Compact 4.0 (.NET framework).
7. In the 'Add Connection' window, set the 'Connection Properties' Database' field to the project.sdf file by selecting 'Browse' and selecting the file in the File Explorer.
8. Select OK.
The project.sdf file should now be in the Database Explorer.
4. View the data or click on any table cell to edit it.
5. Save the project database in Microsoft Visual Studio Express 2012 when you are finished editing.