Importing and Exporting (PostgreSQL) database dump

Importing a dump

A dump import is performed in Infrastructure Administrator. Transferred or backup databases can be imported. A template dump can be created in which all records that are not required are deleted after the import.

To import a dump, do the following in Autodesk Infrastructure Administrator:

  • Connect to the database
  • Open your project
  • Unload the currently used document from the enterprise project
  • Go into the drive and select the dump file
  • Click on the “Import” button

mceclip0.png

Select the import method “Import PostgreSQL database” mceclip1.png

Select the dump

mceclip2.png

Here: Import file: C:\Program Files\...

The dump is imported.

Note

If the dump is to be used as a template dump, it must be opened in the client. Then all objects recorded in it, such as cables, terminators, closures, trenches, ducts, buildings, XRefs, etc., should be deleted. The required models/types used as master data remain intact. This clean dump is then opened in the Infrastructure Administrator and a 1-Click Maintenance is carried out. In the process, problems are searched for and resolved until no more exist. This dump can then be exported and imported at any time as a template for a new project.

 

Exporting a dump

Datasets can be passed on or backup with an export. To export a dump, do the following in Autodesk Infrastructure Administrator:

Open the SQL Sheet

mceclip1.png

Log in as MAPSYS

mceclip2.png

 

Switch to the “Userspaces” tab, right-clicking on the dump Export opens the context menu > Start dump export

The dump is exported. 

mceclip3.png

Select the path and confirm with ENTER.