UserLock Frequently Asked Questions
Migrate SQL Database from a SQL Server to another one
-
On your current SQL Server, open Microsoft SQL Server Management Studio with an account which has admin rights on SQL Server.
-
Select UserLock Database, make a right click to display the context menu, select Tasks then click on Detach.
-
Check the box « drop » to detach the database and drop connections and press OK
-
Copy UserLock DataBase files from your current SQL Server to the new one
-
On your New SQL Server, open Microsoft SQL Server management studio and attach UserLock Database
-
Click Add:
-
Select the new database and click OK:
-
Click Ok to confirm:
-
On UserLock server, open UserLock console. On the menu "Server properties" go to Database section
Go to the DataBase tab and click on the "…" button to modify the connection string
Select SQL Server and press OK
-
A new window will be displayed to configure the connection string
Enter the details related to your new SQL Server (SQL Servername, authentication…)
Press test to check the connection and validate by OK
-
Validate changes in server properties by clicking Apply in the right pane
-
Do not forget to do the same thing in reports section to retrieve data from the Database's location on your new SQL Server