Project Databases

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. Direct 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.

How to Open, View, and Edit a Staffmap Project Database:

  1. Open the project's file directory to find the project database (project.sdf).
    • Example File Path: C:\Program Files\Staffmap 4\Project-Name\data\project.sdf
  2. Make a copy of the project file. This is now a back up in case changes need to be reverted.
  3. Open SqlCe40.
  4. Right click the 'No SQL Server Compact...' message at the top.
  5. From the add dialog, click 'Browse..', navigate to and select the target database file.

6. Close the add dialog.

7. Open the project.sdf dropdown to view tables and information in the project.