Schemas can be copied to a repository on a different server.
For a schema to be copied, Teradata Schema Workbench must be connected to a repository.
- From the main window, click . The Select Cube Schemas dialog box appears with a list of the schemas in the Teradata BI Model Repository.
- Select a schema, and click Open.
- Click .
- View the database connection status bar to ensure it states Not Connected.
- [Optional] If there is risk of overwriting a similarly-named schema in the target Teradata BI Model Repository to keep, rename your schema.
- Click to connect to the database receiving a copy of the schema.
- Publish the schema to this newly-connected database. (See Publishing a Schema to the Database.)