Pattern 3: Migration for batch processes

Migration process designed for critical batch processes. Both processes can be executed in parallel for a comparison period.

Step 1: Model Migration
  1. Using an export or backup of the current DB and LX-LD

Step 2: Application Migration
  1. Migrate application: 99% of the SQL is compatible. For incompatibilities:
    • Alternative SQL will be proposed.
    • LeanXcale will be extended to support the functions used.

  2. Migrate Stored Procedure (e.g., PL/SQL): The procedures are proprietary to the current DB (e.g. Oracle PL/SQL). It will translate to an equivalent java process.
  3. Optimization: Application optimization to take advantage of LeanXcale capabilities (parallelization/multithreading).

Step 3: Data migration
  1. Append-only: Append-only or data with an updating timestamp is migrated. They can be read from backups to avoid overload problems in the production database. Using LX-LD.
  2. Last Day: Last synchronization of the last period (typically the last day) and data without an updating timestamp. It can be performed during an idle window. Using LX-LD.

Step 4: Parallel
  1. Parallel Execution: Execute both processes in parallel for as long as necessary.
  2. Original Database deactivation: LeanXcale remains as the only engine.