How do I erase all of my test data when ready to Go-Live?

To erase all of the data in LobbyCentral, you will need to connect directly to the database. If you are not comfortable working with SQL Management Studio, please contact your IT department for assistance.

Open SQL Management Studio and connect to the LobbyCentral database server.
Select lobbyCentral from the database drop-down list.
Execute the following SQL statements:

Caution! Deleted information is not recoverable! Be sure that you have a verified database backup before executing these statements.

Delete customer check-in history:

SQL

DELETE FROM tblRequest

Delete visitor center history:

SQL

DELETE FROM tblVisitor

Delete customer records:

SQL

DELETE FROM tblCustomer

Delete visitor center companies:

SQL

DELETE FROM tblCompany

Delete custom field values:

SQL

DELETE FROM tblCustomField_Value