The first time you use InfoWorks ICM, you will need to create a database.
If you are using an Autodesk licence, you can create on-premise and cloud databases. If you have an Innovyze licence, you can create on-premise databases but not cloud databases.
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, or a cloud database, is created from within InfoWorks ICM.
- Select Open
Open/Create database from the File menu.
The Open/Create dialog is displayed.
- Click the
Cloud image. The Open/Create database dialog closes and the
Open Cloud Database dialog is displayed.
In this dialog:
- Click New to display the New Database dialog. In this dialog:
- From the Hub dropdown, select the hub where the new
cloud database is to be stored.
Note: Only hubs to which you have access are displayed in the dropdown.
- Specify the name for the new database in the Name field.
- From the Database version dropdown, choose which version of the database is to be used for the new cloud database.
- Click OK. The New Database dialog closes and the name of the database will be displayed in the Database field in the Open Database dialog.
- Click OK.
The Open Database dialog closes and a new database is created.
The cloud 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.
- Select Open
Open/Create database from the File menu.
The Open/Create dialog is displayed.
- Click the Workgroup image. The Open/Create database dialog closes and the
Open Workgroup Database dialog is displayed.
In this dialog:
- Enter the Server name and Server port in the Workgroup Data Server section of the dialog.
- 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:
- Click New in the Database section of the dialog.
The New Database dialog for a workgroup database is displayed:
- If the database is to belong to a group, specify the name for the group in the Group field.
- Specify the name for the new workgroup database in the Database field.
- From the Database version dropdown, choose which version of the database is to be used for the new workgroup database.
- 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.
- Click OK. The Open Database dialog closes and a new database is created.
The on-premise 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.
- Select Open
Open/Create database from the File menu.
The Open/Create dialog is displayed.
- Click the Standalone image. The Open/Create database dialog closes and the
Open Standalone Database dialog is displayed.
In this dialog:
- Click New. This displays a standard Windows Save As dialog.
- Enter the name for the new database file. The name of an existing database cannot be used.
- From the Database version dropdown, choose which version of the database is to be used for the new standalone database.
- Click Save. The Save As dialog closes. The name of the new standalone database is displayed in the Open Database dialog.
- Click OK. The Open Database dialog closes and a new database is created.
The on-premise 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.