[ ASManager ] Migrate ASManager MDB to MSSQL - 20210126
Posted: January 26th, 2021, 1:55 pm
Question:
How to migrate ASManager MDB to MSSQL?
Answer:
Below steps can help you migrate your current access control, ASManager Database from the MDB to the MSSQL Server.
To do so, please follow the steps below:
a. Disconnect PC Ethernet network first, this can keep the controller(SDCard inserted) records at each of controller hardware(PC-LPR will stop working).
b. Close the ASManager Main UI and run the ASMiniService.exe which is located at the installed folder(default: C:\Access Control\ASManager)
c. Backup the current MDB files via the ASDBManager
* You can keep the second copy for ASRes folder in case you don’t lost your data.
d. change the database type for ASManager from Access to SQL
and then input the credential of the SQL Server for access the database
* Notice: the test buttons are confirmation, no data checking.
* Notice2: you can consider to enable the [Expand Data Size] option in order to unblock the record limits for your SQL Server
e. once you done the SQL Connection, then you select the [Recovery] to restore from the MDB database
f. after take a while to finish it and close the ASDBManager, you can restart the ASManager Main UI to use the ASManager with SQL Server DB usage.
For your usage of the MSSQL server, you can refer the below information about how to use it for the database service
You can use the Microsoft SQL Server to make sure the database is no longer failed or unauthorized edit(login required).
SQL Server Installation Guide:
https://learn.microsoft.com/en-us/sql/d ... rver-ver16
Plus the auto-mirror-backup feature by the SQL Server itself is also the way to prevent the data lost. we also searched some other videos on Youtube you can check it(ENG).
How to download Microsoft SQL Server 2022 Express Edition installation setup file
https://www.youtube.com/watch?v=MrwdjYbPZFg
Microsoft SQL Server 2022 Express Edition Installation on Windows 10 | MS SQL Server 2022 Connect with SSMS v19
https://www.youtube.com/watch?v=T9DC5CiWUf4
* No limits to use these source.
* Does not represent the GeoVision recommendation, only search result.
Reference:
FW: 202011032003 [Access Control] RE: Geovision Access Control
How to migrate ASManager MDB to MSSQL?
Answer:
Below steps can help you migrate your current access control, ASManager Database from the MDB to the MSSQL Server.
To do so, please follow the steps below:
a. Disconnect PC Ethernet network first, this can keep the controller(SDCard inserted) records at each of controller hardware(PC-LPR will stop working).
b. Close the ASManager Main UI and run the ASMiniService.exe which is located at the installed folder(default: C:\Access Control\ASManager)
c. Backup the current MDB files via the ASDBManager
* You can keep the second copy for ASRes folder in case you don’t lost your data.
- 1.png (134.05 KiB) Viewed 3969 times
d. change the database type for ASManager from Access to SQL
and then input the credential of the SQL Server for access the database
* Notice: the test buttons are confirmation, no data checking.
* Notice2: you can consider to enable the [Expand Data Size] option in order to unblock the record limits for your SQL Server
- 2.png (198.8 KiB) Viewed 3969 times
e. once you done the SQL Connection, then you select the [Recovery] to restore from the MDB database
- 3.png (101.47 KiB) Viewed 3969 times
For your usage of the MSSQL server, you can refer the below information about how to use it for the database service
You can use the Microsoft SQL Server to make sure the database is no longer failed or unauthorized edit(login required).
SQL Server Installation Guide:
https://learn.microsoft.com/en-us/sql/d ... rver-ver16
Plus the auto-mirror-backup feature by the SQL Server itself is also the way to prevent the data lost. we also searched some other videos on Youtube you can check it(ENG).
How to download Microsoft SQL Server 2022 Express Edition installation setup file
https://www.youtube.com/watch?v=MrwdjYbPZFg
Microsoft SQL Server 2022 Express Edition Installation on Windows 10 | MS SQL Server 2022 Connect with SSMS v19
https://www.youtube.com/watch?v=T9DC5CiWUf4
* No limits to use these source.
* Does not represent the GeoVision recommendation, only search result.
Reference:
FW: 202011032003 [Access Control] RE: Geovision Access Control