Console Mode

Run any migration from a JSON file. Drop it in CI/CD, schedule it, audit it. The full UI feature set is available headless. No exceptions.

Scripting and automation

Every option you can click is also a JSON key. No second-class headless API.

Vision illustration

How does it work?

One command, one JSON file:

OmniLoader.exe -job \path\to\the\file.json

By default, every table from every source moves to the target. Want to copy a subset? List them in the JSON. Need per-table customization? It's per-table in the JSON, too. Multi-source migrations use a Sources array instead of a single Source. The docs cover the rest.

Why teams reach for console mode

Declarative JSON beats clicking through tabs. Every customization is right there in front of you. No hunting through screens to remember what was set last.

When a teammate picks up the project, the file tells them everything they need to know in five minutes.

And because it's a file, it goes in source control. Code review, audit trail, and rollback for free.

Mission illustration

SQL Server authentication

{
  "SqlServer": {
    "Server": "{{server}}",
    "Database": "{{database}}",
    "Username": "{{username}}",
    "Password": "{{password}}"
  }
}

Omni Loader

console arguments

Run a job and exit. Built for automated migrations and CI/CD pipelines.

--job {path-to-json-file}

A JSON job specification to use. A typical example would be:

OmniLoader.exe --job c:\jobs\sql2synapse.json

--cluster

Run Omni Loader in a distributed cluster mode. Omni Loader becomes a cluster orchestrator and waits for agents to connect to it.

OmniLoader.exe --cluster

--urls {http(s)://ip-range:port}

Listen for incoming connections. A typical example would be:

OmniLoader.exe --urls http://0.0.0.0:5000

--listen-at {http(s)://ip:port}

In cluster mode, this is a public orchestrator IP:port combination that will be sent to agents when they connect. Agents will send data to the API on specified port.

OmniLoader.exe --cluster --urls http://0.0.0.0:5000 --listen-at http://192.168.1.100:5000

--activate {activation code}

In console mode and CI/CD workflows, you can activate Omni Loader even without firing up the GUI.

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

Frequently asked
questions

Save time. Get the job done.

Tell us what you're moving.