Move Badge Data From a QAS SQL Database to a Lynx Database
- 21 Sep 2023
- 1 Minute to read
- Contributors
- DarkLight
- PDF
Move Badge Data From a QAS SQL Database to a Lynx Database
- Updated on 21 Sep 2023
- 1 Minute to read
- Contributors
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Move Badge Data from a QAS (QwickAccess Server) SQL Database to a Lynx Database
Problem/Need:
Customers upgrading from QAS to Lynx would like to import the username/badge associations from the QAS database into the Lynx database.
Summary:
This document explains how to import the QAS prox/user associations from the QAS database to the Lynx database.
Requirements:
- This only applies to customers who have a QAS SQL database.
- Users must have access to the QAS SQL database.
- The new Lynx database has already been created.
Steps:
- Open SQL Management Studio (or a similar utility that will allow you to connect to run SQL queries).
- Connect to both the new Lynx database and the old QAS database.
- Select the Lynx database.
- Create a new query.
- Use the following syntax to import the records from the old QAS database into the Lynx database (update QADB in the text to the name of the QwickAccess 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]
6. Run the query.
Was this article helpful?