Move Badge Data from QAS SQL Database to Lynx Database

This article is for upgrading from the QwickAccess Server (QAS) to Lynx server and you need to import the username/badge associations from the QAS database into the Lynx database.

Requirements:

• Users must have access to the QAS SQL database.
• The new Lynx database must already be created.

Steps:

1. Open SQL Server Management Studio (SSMS) or similar utility that allows you to connect to and run SQL queries.

2. Connect to both the old QAS database and the new Lynx database.

3. Select the Lynx database.

4. Create a new query.

5. Use the following query to import the records from the QAS database into the Lynx database:

   INSERT INTO [Lynx].[dbo].[ProxCardUsers] (BitCount, IsDisabled, CardID, LogOnTo, PIN, TimeStampUtc, Username)
   SELECT BitCount, 0, SerialNumber, LogOnTo, PIN, TimeStamp, Username
   FROM [QADB].[dbo].[ProxCards]
   

   • Note: Update "QADB" on the final line with the name of your QwickAccess database.

6. Run the query.