1. Data Migration User Guide
  2. Data Migration

1 Data Migration

This topic provide information about the Data Migration.

The table that holds the data for the scheduled sweeps has been moved from the schema of batch service to the schema of sweep service.

The name of this table is changed from LMB_TB_BATCH_DATA to LMS_TB_SWEEP_DATA. For newly created structures, the data gets saved directly to the new table but for the existing data, migration must be done manually.

Follow the below steps to manually migrate the data using Oracle SQL Developer.

  1. On Oracle SQL Developer application, create a new connection for Batch and Sweep schema by providing the required information
    The Oracle SQL Developer - Login Screen application screen displays.

    Figure 1-1 Oracle SQL Developer - Login Screen


    Description of Figure 1-1 follows
    Description of "Figure 1-1 Oracle SQL Developer - Login Screen"

  2. Specify the login Credentials and click Connect to connect with batch schema.
    The Oracle SQL Developer screen displays.

    Figure 1-2 Oracle SQL Developer


    Description of Figure 1-2 follows
    Description of "Figure 1-2 Oracle SQL Developer"

  3. Under Tables, right-click on LMB_TB_BATCH_DATA and click Export to export the existing data.
    The Export Wizard - Source screen displays.

    Figure 1-3 Export Wizard - Source


    Description of Figure 1-3 follows
    Description of "Figure 1-3 Export Wizard - Source"

  4. Uncheck the Show Schema checkbox and select the file name.
  5. Click Next.
    The Export Wizard – Specify Data screen displays.

    Figure 1-4 Export Wizard – Specify Data


    Description of Figure 1-4 follows
    Description of "Figure 1-4 Export Wizard – Specify Data"

  6. Click Next.
    The Export Wizard – Export Summary screen displays.

    Figure 1-5 Export Wizard – Export Summary


    Description of Figure 1-5 follows
    Description of "Figure 1-5 Export Wizard – Export Summary"

  7. Click Finish.
    The File Exported screen displays.

    Figure 1-6 File Exported


    Description of Figure 1-6 follows
    Description of "Figure 1-6 File Exported"

  8. Remove all the DDL statements from the file and retain only the insert statements.
  9. Replace all the instances of LMB_TB_BATCH_DATA with LMS_TB_SWEEP_DATA
  10. In the Connection drop-down, select the Sweep Schema.
    The Sweep Schema screen displays.

    Figure 1-8 Sweep Schema


    Description of Figure 1-8 follows
    Description of "Figure 1-8 Sweep Schema"

  11. Press F5 button to execute the script.