Copying user tables

Note: This topic applies only in an on-premises environment.

If you upgrade your application from one version to another version, you can copy your user and group authorizations to the new version with the Copy User Tables utility, so you do not have to set them up again.

  • This utility should only be used when you first set up a database for use, and not after users are defined, and Foreign Key references are added.
  • The latest version of your application must be installed and licensed before you run this utility.
Note: If your latest license is for fewer users than your old license, not all users will carry forward. When you complete the procedure, open the Users form in the new version of your application to check the users, and then make changes accordingly.
  1. In the Apps section of the Application Server, open the Copy User Tables utility.
  2. On the Source tab, provide this information:
    SQL Server Name
    Select the name of the server.
    SQL Server Login ID
    Specify the login ID.
    SQL Server Logon Password
    Specify the password associated with the login ID.
    Use Windows Authentication
    Select this check box to log in automatically to the server, using the username of the person currently logged in to the Windows machine, instead of supplying a SQL Server login or password.
    Source Database
    Select the name of the Application Database that has the user or group authorizations that you want to copy.
  3. On the Target tab, provide this information:
    SQL Server Name
    Select the name of the server.
    SQL Server Login ID
    Specify the login ID.
    SQL Server Logon Password
    Specify the password associated with the login ID.
    Use Windows Authentication
    Select this check box to log in automatically to the server, using the username of the person currently logged in to the Windows machine, instead of supplying a SQL Server login or password.
    Target Database
    Select the name of the Application Database to which you want to copy the user or group authorizations.
  4. On the Login tab, provide this information:
    User ID
    Specify the user ID.
    Password
    Specify the password associated with the user ID.
    Data Source Config
    Select the target application database.
  5. Click Copy.

The status bar shows the progress. The process can take several minutes.

In the directory of the Application Server, a UserTables.txt file is created. This file lists the tables that were copied by the Copy User Table utility.