A database provides a flexible hierarchy for managing
asset data and contains all data including
ground models.
The following types of databases are available with
InfoWorks software:
- Workgroup - An
on-premise database intended for use by individuals and groups of users. Requires the use of the
Workgroup Server software, provided by us to manage access to these types of databases. The software was designed to improve the performance and reliability of database operations in a workgroup environment. To share the database as part of a workgroup, it must be located on a machine where it can be accessed by all users.
The following types of
on-premise workgroup databases are available:
- Standard (WorkGroup) Database
- SQL Server (WorkGroup) Database
- Oracle (WorkGroup) Database
SQL Server and Oracle workgroup databases requires your own Microsoft SQL Server or Oracle database installation.
- Standalone - An
on-premise database intended for use by individual users working on a single PC. This type of on-premise database is only appropriate for use on a standalone machine.
- Cloud
- A
cloud database intended for use by individual and multiple users. Access to
cloud databases is handled by the cloud data service, which is managed by
Autodesk. This lets you take advantage of the unlimited storage and increased processing capabilities of the cloud and removes the need to set up and maintain an internal server that is required for workgroup
on-premise databases.
Note:
Cloud databases are not available in
InfoAsset Manager.
When a database is created, local working copies of parts of the data are then made available in each user's
Local Folders.
Database identifiers
Each
database has a
Unique Database Identifier. When a new database is created, this identifier is generated automatically as a string of letters and numbers taking the form
629810C2-3F6B-11D3-9BF3-00600891B690.
Database versions
Each database has a version number. For example, a database created with version 2023.0 of the software will have a database version of 2023.0. You can choose which version of the database is to be used when you create a database. This can be useful if you collaborate with other users who do not work with the same version of
InfoAsset Manager as you.
- If you work with a database that is earlier than the version of the software you are using, for example, database version 2023.0 with software version 2023.1, you may not be able to access all the new features that are available in the newer version of
InfoAsset Manager. The availability of a new feature depends on whether or not it requires database tables and fields, such as object properties or a database item, that are only available in the newer version of the database, or if there have been other changes that may affect results.
- You can
update an earlier version of a database to a newer one. This lets you access all the features available in the newer version of the software. However, the updated database cannot be used, by you or any other user, in an earlier version of the software.
- You cannot paste data
copied from a database which has a newer database version than the database you are pasting to.
The version number of the currently selected database is displayed in the
Explorer window.
View database properties
Database properties can be viewed from the
Explorer Window.
- Right-click on the database icon in the tree view in the
Explorer Window and select Properties from the context menu to display the
About Box.
- Hover the mouse cursor over the database icon in the tree view to display a tooltip including database path and GUID information.