Create a Database

The first time you use InfoAsset Manager, you will need to create a database.

SQL Server or Oracle workgroup databases are created using the tools supplied with the database installation. Innovyze provides scripts to format the new database correctly.

A standard on-premise workgroup or standalone database is created from within InfoAsset Manager.

To create a standard workgroup database
Warning: DO NOT KEEP YOUR DATABASE IN YOUR LOCAL FOLDER DIRECTORY. You run a risk of corrupting your data because Local Folder and Remote Root files may now be saved in the same directory, and these files can potentially have identical names.
  1. Select OpenOpen/Create database from the File menu.

    The Open/Create dialog is displayed.

  2. Click the Workgroup image. The Open/Create database dialog closes and the Open Workgroup Database dialog is displayed.

    In this dialog:

  3. Enter the Server name and Server port in the Workgroup Data Server section of the dialog.
  4. Click Connect. The Status field indicates whether or not a connection is established. A message will also be displayed if it is not possible to connect to the server, and you may need to ask your system administrator for assistance.

    When connected:

  5. Click New in the Database section of the dialog.

    The New Database dialog for a workgroup database is displayed:

  6. If the database is to belong to a group, specify the name for the group in the Group field.
  7. Specify the name for the new workgroup database in the Database field.
  8. From the Database version dropdown, choose which version of the database is to be used for the new workgroup database.
  9. Click OK.

    The New Database dialog closes and the names of the group and database will be displayed in the Group and Database fields in the Open Database dialog.

  10. Click OK. The Open Database dialog closes and a new database is created.
    The workgroup database is made up of:
    • A basic index file with the database name as specified above and an .icmm extension.
    • A data subdirectory of the directory where the .icmm file is located, which will contain the database data. The directory name is automatically generated and will be the same as the database unique identifier.
To create a standalone database
  1. Select OpenOpen/Create database from the File menu.

    The Open/Create dialog is displayed.

  2. Click the Standalone image. The Open/Create database dialog closes and the Open Standalone Database dialog is displayed.

    In this dialog:

  3. Click New. This displays a standard Windows Save As dialog.
  4. Enter the name for the new database file. The name of an existing database cannot be used.
  5. From the Database version dropdown, choose which version of the database is to be used for the new standalone database.
  6. Click Save. The Save As dialog closes. The name of the new standalone database is displayed in the Open Database dialog.
  7. Click OK. The Open Database dialog closes and a new database is created.
    The standalone database is made up of:
    • A basic index file with the database name as specified above and an .icmm extension.
    • A data subdirectory of the directory where the .icmm file is located, which will contain the database data. The directory name is automatically generated and will be the same as the database unique identifier.
Parent topic: On-premise and Cloud Databases