UserLock Documentation
UserLock Documentation

UserLock Frequently Asked Questions

Migrate SQL Database from a SQL Server to another one

  1. On your current SQL Server, open Microsoft SQL Server Management Studio with an account which has admin rights on SQL Server.​​

  2. Select UserLock Database, make a right click to display the context menu, select Tasks then click on Detach.

    select Tasks then click on Detach

  3. Check the box « drop » to detach the database and drop connections and press OK

    Check the box « drop » to detach the database

  4. Copy UserLock DataBase files from your current SQL Server to the new one

    Copy UserLock DataBase files

  5. On your New SQL Server, open Microsoft SQL Server management studio and attach UserLock Database

    attach UserLock Database

  6. Click Add:

    Click Add

  7. Select the new database and click OK:

    Select the new database and click OK

  8. Click Ok to confirm:

    Click Ok to confirm

  9. 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

    Select SQL Server and press OK

  10. 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

    Press test to check the connection and validate by OK

  11. Validate changes in server properties by clicking Apply in the right pane

    Validate changes in server properties

  12. Do not forget to do the same thing in reports section to retrieve data from the Database's location on your new SQL Server

    Database's location