Import Tablespace Script (attach_planner.bat)

To use the import tablespace script:

  1. Navigate to the directory JDEdwards\E920\planner\data and run this script:

    TestPlannerDBs.bat

  2. Edit the attach_planner.bat file such that any tablespaces that you do not intend to import are commented out. These lines start with:

    call %DATA_PATH%\IMPORT_TABLESPACE.BAT

  3. Open a command prompt window by right-clicking on a Command Prompt shortcut and selecting Run as administrator.

  4. Change directory to the location of the batch files.

  5. Run the batch file to import the tablespace using this syntax:

    attach_planner.bat <database_password> <E1_install_dir>

    For example:

    attach_planner.bat default c:\JDEdwards\E920

    Note: This import batch file for the local metadata repository is in the spec directory:attach_metadata.bat