CYBERTEC Migrator Documentation
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage Support

Migration Settings

The Settings tab provides configuration options for the migration, from general details to export utilities. The tab is organized into several sections, each addressing different settings categories.

General

Contains basic information fields:

  • Name: A text field for modifying the name of the migration.
  • Description: An optional text field for adding descriptive information about the migration.

Credentials

Allows configuration of authentication details for the databases involved:

  • Username and Password: Update the credentials for either the source and target databases.

Parallel Workers

Includes settings for managing concurrency during migration stages:

  • Data Transfers: Specify the maximum number of parallel transfers allowed during the data stage.
  • Database Workers: Control the maximum number of parallel workers for the integrity stage.

Progress Interval

  • Progress Interval: Defines the interval, in seconds, for reporting the transfer status to the migration log. At each interval, the system logs the amount of bytes and rows transferred.

Utility

Generates a .zip archive containing detailed migration metadata and associated files. The exported archive includes:

  • manifest.json: Metadata about the migration, such as version numbers, timestamps, connection details, and unique identifiers.
  • mappings.json:
    • meta_data: Complete information about the source schema.
    • user_mapping: Contains the latest revisions of user-applied changes.
    • hooks: Contains the latest revisions of stage hooks.
  • <migration name>: A folder named after the migration, containing subdirectories for database objects: functions, package bodies, packages, procedures, triggers, and views. These subdirectories house database object files, each containing:
    • <object>.sql: The original source database code.
    • <object>.sql.0: The code post automatic conversion by the Migrator.
    • <object>.sql.<revision number>: The latest user-modified version, with the revision number indicating the state at the time of export.