Copying Databases

You can copy the databases of applications for which you have Application Manager permissions and applications to which you have appropriate access. You cannot copy a database to a target Essbase Server whose version precedes the version of the source Essbase Server.

Databases copied from non-Unicode-mode applications to Unicode-mode applications are converted to Unicode-mode. You cannot copy databases from Unicode-mode applications to non-Unicode-mode applications.

When databases are copied, settings related to member name uniqueness requirements are retained, and database directories (ARBORPATH\app\appname\dbname) are created on the target servers.

You can copy databases between Essbase Servers (for example, from a development server to a production server) or within an Essbase Server (for example, for testing or backup). Essbase copies databases between servers and within servers differently.

You can copy databases only to existing applications. If necessary, on target servers, you can create the applications that will contain the databases.

To copy databases, you can use the following procedure or use Migration Wizard. You should not use the file system to copy, move, rename, or delete databases. For information about using the file system to manage applications and databases during backup, see the Oracle Essbase Database Administrator's Guide.

Note:

You cannot copy aggregate storage databases. However, you can copy aggregate storage applications.

  To copy databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Copy.

  3. In the Copy Database dialog box, select the Essbase Server to contain the database copy.

  4. In the Application list, select the application to contain the database copy.

  5. In Database name, enter a name for the database copy.

  6. Click OK.

    Essbase copies the database and updates Enterprise View.

Related Information

Related Commands