Work on the database

Disconnect users from the database

Repository > Database

To run maintenance operations or tests on the database, it may be necessary to disconnect all the users who are working on it.

  • To warn users that they are about to be disconnected from a database, select the database in the list then click > Notify disconnection to connected users and confirm: users connected to the database will receive a warning message.
  • To disconnect users from a database, select the database in the list, click > Disconnect users and confirm: all connected users will immediately be disconnected.

Export tables from a database

Repository > Import/Export > Export

This procedure creates a compressed file containing all or some of the tables from an individual database.

  1. In Databases, select the database to be exported.
  2. In Tables to export, select the desired tables only.
  3. To also automatically import all the tables to which the selected tables make reference, click Add referenced tables
  4. To also automatically import all the tables that refer to the selected tables, click Add referring tables .
  5. Click Run to export the selected tables: the generated file or files will be listed in Exported files.

To check any problems during the export, refer to the end-of-process log or Audit page.

Import tables from a database

Repository > Import/Export > Import

  1. In File location, select the location of the files to be imported.

Note: if the exported database has been split into several files, they must be located in the same folder in order to be imported. 2. Select the file and upload it.

Note: depending on the file location, different identifying information will be required. 3. In Databases, select the database on which to import data. 4. Select the tables to be imported.

IMPORTANT: only importing some tables could compromise the integrity of the data. For partial imports, create a dedicated export file. 5. If you also want to import the ANALYTICAL_WORKSPACE_TABLES table, in Advanced options, Write mode select Deletion/Insertion. 6. Set the desired options in Advanced options then click Run: the tables will be imported immediately.

IMPORTANT: if the imported database version is less recent than the current one, this may lead to import errors. In such cases, a detailed warning message will appear.

To check any problems during the import, refer to the Audit page.