Creating a Location

+ More

This is how a new location is created, i.e. a new Empirum Database is created under SQL:

  1. Select Menu Actions > Create Location... or click on the icon DBUtil_Hinzufuegen.
    You get to a dialog for entering the location parameters:

DBUtil_StdErst

  • Database server: Enter the name of the server, on which the new Empirum database is to be created.
  • Database user name: Name of the database user, for logging on to the database server (e.g. "sa").
  • Password: Individual character sequence for identifying a database user.
  • Logon to Remote Computer: Option not activated: The location database is installed locally.
    Option activated: The location database is installed on the remote computer.
    • Operating System Logon Name: Name description of the user for logging on to the remote computer. (e.g. <Domain>\Administrator).
    • Password: Individual character sequence for identifying the logon name.
  1. Enter the Parameters for the new local location or the new remote location.

If the Empirum database is to be installed on a remote computer, the control box Logon to Remote Computer has to be ticked and the logon information has to be entered.

  1. Click on the Next button.
    You get to a dialog for entering the location parameters.
  2. Enter the name for the location database, and if necessary, a description.
  3. Confirm your entries with the Finish button.
    You get back to the main dialog of Empirum DBUtil. Now you can see the location database you just created.
  4. Select Menu Actions > Create Tables... or click on the icon DBUtil_Tabellen in order to create the database layout in the database.
    You get to an additional dialog:
    DBUtil_ServerUmb0000
  • Local: You are logged on directly to the Empirum Server (Central Database)
  • Remote: You are creating an additional database. The source files of this location are located on a remote computer, which then has to be specified under Remote.
  1. Enter the name of the Empirum Server for the source files of this location and confirm with OK.
    After the database layout is created, you receive the message, that the database was successfully configured.
  2. Confirm the message with OK.

The Empirum database has now been set up correctly. The main dialog of Empirum DBUtil with the newly created location database is displayed.

Related Articles