Import/export

OTAP support enables you to easily import/export schemas from test to production or from environment A to environment B. While using this all IDs and references will stay the same making it very easy to migrate your workbooks as well. Schemas can be migrated between different database drivers. Importing a schema will only import the schema structure, data is not migrated.

Export Schema

To export a schema click on the chosen schema and on the top right of the schema screen you will see ‘Export’ button. One click on the export button will download the schema as a Json file. Save the file locally, this can then be imported to the environment of your choosing.

Important

When importing a schema into a target environment, ensure that the schema name and label are unique within the selected connection. If a schema with the same name already exists, the import may fail due to a name conflict. If required, edit the exported schema to use a unique name and label before importing.

Import Schema

To import a schema to your environment head to the schema tab and you will see an import button.

Here you can connect to select the connection where to import your schema. Upload the Json file that has been exported, if you are important in the same environment as where you exported, be sure to rename the label and table.