Include and Copy Foreign Databases

You can copy databases from other projects. Databases can also be shared between many projects, which saves disk space and eliminates errors which could be caused by copying. Catalog databases are often shared in this way.

Databases included from a second project are also known as foreign databases. The second project must be available: that is, the user must be able to read from the second project directory, and have the environment variables for the second project set.

When you create a project that is going to share databases from other projects, there are two important considerations:

• Teams must exist for all databases that are to be shared.

• Databases in the source project that will be shared must not be given a database number that will clash with a database number that already exists in the destination project.

  Note:
  Foreign databases are marked with * in the database list.

Click Database and Extracts on the Manage tab. Select the database to include and click Include. The Include Foreign Database window is displayed.

• Foreign Projects lists the other projects available.

• Access Project as. Username and Password are mandatory.

• Foreign Databases lists the databases in the foreign project.

• Select the required databases and click Apply. The user will be prompted to create the owning team, if it does not already exist in the current Project. The user cannot include a database which has the same teamid/dbname as an existing database in the current project.

To exclude foreign databases, click Database and Extracts on the Manage tab and click Exclude. The Exclude Foreign Databases window is displayed. Select the foreign databases to exclude and click Exclude.

To copy a foreign database, click Database and Extracts on the Manage tab and click Copy Foreign. The Copy Foreign Database window is displayed.

• Foreign Projects lists the other projects available.

• Access Project as. Username and Password are mandatory.

• Foreign Databases lists the databases in the foreign project.

• Target Database name is set as follows: pick the team which will own the database from the list, and enter the database name.

• Click Apply. The user cannot include a database which has the same teamid/dbname as an existing database in the current project.