Skip to content

Workspace data exchange

Users can exchange data between workspaces through two standard Workbench tools - Data Export Tool and Data Import Tool. The two tools are available through the Tools Explorer

The data exchange concept is based on users exporting data entities from a source workspace to the file system and then importing them in a target workspace.

Note

Note: Data exchange will during import restore the data entities in the same group folders as they had in the source workspace. This implies that data exchange can override data within the target workspace.

Note

Also note that when exporting and importing, the version of MIKE Workbench used for importing data, should be the same as the one used when exporting data.

The export and import tools can be used for moving data from one database type to another.

This includes moving to other database types.

Data export and import are able to handle the following types of data:

  • Documents Document from the Document Explorer.

  • Feature classes Feature classes from the GIS Explorer.

  • Rasters Raster from the GIS Explorer. Only raster in the database can be exported. Remote file-based rasters cannot be exported.

  • Script storages Scripts can be exported when viewing script by script storage.

  • Spreadsheets Spreadsheets from the Spreadsheet Explorer.

  • Time series Time series from the Time Series Explorer.

  • Scenarios Exporting a scenario will include the model setup, indicators of the scenario (if any) and time series included in the scenario.\ Exporting a scenario, will not export simulations of the scenario.

  • Simulations Exporting a simulation will include the scenario of the simulation with time series included in the scenario, the model setup including time series, indicators of the scenario (if any) and input and output time series of the simulation.

Export data

Select the Export Data Tool (1) and click the Run button (2) in the tool's property control. This will make the Export data to disk view available.

Specify a folder (3) where the exported data entities can be stored.

Then drag and drop (4) the entities that shall be exported from the respective managers to the view.

Note

Note that the entities are being exported as they are being dragged and dropped to the view.

Import Data

Select the Import Data Tool (1) and click the Run button (2) in the tool's property control. This will make the Import data from disk view available.

Select the folder (3) that contains the exported data. The exported data entities will then be listed in the view.

Click the Start button (4) and the import of entities will start

Move from SQLite to PostgreSQL

The export and import tools can be used for moving data from one database type to another. This includes moving from a SQLite database to PostgreSQL database.

This guide can be used for moving from any type of supported database to other types of supported databases (SQLite, PostgreSQL, MS SQL Server).

Export data from SQLite

Start MIKE Workbench connecting to the SQLite database to move from.

In the Tools Explorer, select the Data Export Tool and specify the "Export path" to export data to.

Note that the user exporting data should have write access to the folder specified.

Click the "Run tool" button to display the data view of the Data Export Tool.

Drag entities from the explorers and drop them on the data view of the Data Export Tool.

When dropping an entity, the entity is automatically exported to the folder specified. If the folder does not exist, it will automatically be created.

Tabs are created in the data view for every type of data exported.

The export folder will contain sub folders with the different types of entities exported.

Import data to PostgreSQL

When all entities to be moved to the new database has been exported, start MIKE Workbench using a connection to the PostgreSQL database to move the data to.

Note that the export contains information about the version of MIKE Workbench used for exporting data. The data import requires that the version of MIKE Workbench matches the version of the export.

In the Tools Explorer, select the "Data Import Tool" and specify the folder where data has been exported to.

Click the "Run tool" button to open the data view for importing the data.

The Data View "Import data from disk" will list all entities exported in tab pages.

To import, click the Start button.

When the import has completed, all imported entities can be found the explorers associated to the entities.