Transportable Databases
Transportable databases are used for copying data between existing master databases. The master databases may be on different computers.
A transportable database can store an entire database, or parts of a database, or even data from several master databases.
Transportable databases allow the integrity and quality
of data to be maintained when copying it from one database to another. All the relationships
in the database
The transportable and master databases may have different database versions. You can copy data from a transportable database that has older database version than the master database. However, you cannot copy data from transportable database that has a newer version than the master database unless you
Typically, a transportable database would be used to:
- Transfer data between multiple sites within an organisation.
- Send data to or from contract teams working on particular projects.
- Send data to Innovyze for investigation.
Transportable database files can be copied using the Windows Explorer or other file-copying tools.
A transportable database must be closed in InfoWorks ICM before it can be moved or copied.
See Copying Data Between Databases for details on using transportable databases.
Create a transportable database
To copy data from a database other than the current database:
- Choose Open | Open/Create master database from the File menu. Select the relevant master database.
- Display an Explorer Window of the database by selecting New Explorer window from the Window menu.
- Select Open | Open new transportable database from the File menu. A standard Windows Save as dialog is displayed.
- Type a name for the transportable database.
- From the Database version dropdown list, choose which database version is to be used for the new transportable database.
- Click OK. The transportable database is given an ICMT extension. An Explorer view of the transportable database is displayed.
- You can now copy data to the transportable database from the master database.
When you have finished with the transportable database, close the Explorer view.
Open a transportable database
A transportable database can be opened and viewed in an Explorer window.
To open a transportable database:
- Select Open | Open transportable
database from the File menu. A standard Windows Open dialog is displayed.
This dialog displays all standard transportable databases (which have an ICMT extension).
- Select the transportable database file and click Open.
The database is then displayed in an Explorer View.
Note:
- A transportable database of version older than v2.0 must be updated before it can be opened.
- An older format transportable database that is newer than v2.0 may be opened read-only and items copied from the transportable to the current database without the need for updating. Prompts will be displayed as appropriate.
See below for instructions on updating a transportable database.
Update a transportable database
You may want to update a transportable database when you want to paste data from a database that has a newer version than it.
To update a transportable database:
- Select Database update | Update transportable database from the File menu.
The Update Transportable Database dialog is displayed. In this dialog:
- Click Browse.
A standard Windows Open dialog is displayed.
- Select the applicable transportable database file. Transportable databases have an ICMT extension.
- Click Open. The Open dialog closes and the name of the selected transportable database is displayed in the Update Transportable Database dialog.
- In the Update to dropdown, select the database version that you want the transportable database to be update to.
- Click Open. The transportable database will now be formatted with the selected version.