Omni Loader can be invoked as a console application to execute a job and return. This is very useful for automated migrations and migrations as part of CI/CD workflows.

First create your project through the GUI, configure the desired options, and select the tables you want to process.

Make a note of either the project ID (visible in the project list) or the exact project name, as one of these will be required to reference the project when running Omni Loader from the command line.

Omni Loader console arguments

-n, --project-name {project_name} -i, --project-id {project_id}

Run a project without opening the GUI by specifying either the project name or project ID.

OmniLoader.exe --project-name "My tetst project"
OmniLoader.exe -i 23

-l, --license {activation code}

In console mode and CI/CD workflows, Omni Loader can be activated without launching the GUI.

OmniLoader.exe --job c:\jobs\sql2synapse.json --activate 12345-6789-0000

-t, --tables {schema1.table_name1;schema2.table_name2;...}

If not specified, the project runs using the table selection defined in the project. Use this argument to run only a specific subset of tables.

OmniLoader.exe -i 23 -t "dbo.Order;dbo.OrderDetails;sales.Pricing"