Importing Database

About Importing Database

This option allows you to duplicate an CES database. It is used with EDM's Export Database option. Before importing, prepare for the import by creating an empty CES database with seed data. This will be the target database and will have the same database configuration as the source database from which an export was made.

  1. Create an empty CES database with the same configuration (codeset, buffer pools, tablespaces) as the source database.

  2. Load Explore seed data.

  3. Copy the entire export directory onto your server. Ensure that the permissions to this directory are set to 777.

  4. Login as cisdba and run edm.sh from $EDS_HOME/bin directory. For additional information see Using Explore Database Manager.

This task explains the procedure to import a database:

  1. From the EDM main window, select a database.

  2. Select Administration > Import an Explore Database option.

    The Import an Explore Database window appears
    .

     

    Name Description

    Instance Name

    The name of the instance.

    Database Name

    The name of the database to be imported.

    Import Directory

    The path to the directory where the exported files reside.

    Import Log File

    The log file in which the import details will be stored. The default log file and path appears but you can click Browse and select a different file/path.

  1. Click Import to start the database import. This Import takes some time depending on the size of the database.

  2. Once the database is imported, click Cancel to return to the EDM main menu.