# Migration

### ![](https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-b1ff09efdc12bf5f66706c589ab22a99da1cb7dd%2FIcon_TOB_program.gif?alt=media)

### Abstract

This plug-in enables a 1:1 data migration between different database technologies with automated database detection.

You can also integrate and run your own migration executable (.exe) directly within OMrun.

The migration modul comes with a predefined generic template.

***

### Input

Execution parameters to invoke a migration:

**Field `Program Call`** Select "DataMigration" from the drop down menu.

**Filed `Data Link Source`** Select the alias for the source database from the drop down menu.

**Filed `Data Link Destination`** Select the alias for the target database from the drop down menu.

**Field `@param1`** (Source) Source Database-Schema and TableName \[mandatory]

* Description: Source database schema and table name.
* Syntax: \<source\_schema.table>
* Example: "DEMO\_SOURCE.EMPLOYEE"

**Field `@param2`** (Destination) Destination Database-Schema and TableName \[mandatory]

* Description: Destination database schema and table name.
* Syntax: \<destination\_schema.table>
* Example: "DEMO\_DESTINATION.EMPLOYEE"

**Field `@param3`** (DropMode), overwrites the true (default) setting from config file. \[optional]

* Description: Create/Re-Create or Truncate/Re-Load destination Table.
* Syntax: \<DropMode>
  * \<empty> the default value true is set / drops and re-creates destination table
  * \<true> drops and re-creates destination table
  * \<false> truncate and re-loads destination table
* Example: "false"

**Field `@param4`** (Exclude Columns), list of column names excluded (max.1000) from the migration to the destination table \[optional]

* Description: Defines the column names of a table not migrated to the destination table.
* Syntax: \<col1,col2>
  * \<empty> No column is excluded from migration.
  * \<col1,col2> All columns of a table are migrated to the destination table except the listed columns.
* Example: "id\_old,migration\_text"

***

### Output

The output is the migrated data table.