Console Mode allows you to script and automate your migrations without ever needing to use our web-based user interface.
All of the functionality exposed in the web-based UI is available in the console mode as well.
Run the OmniLoader executable with an additional -job parameter specifying the path to the JSON file. An example (Windows variant):
By default, the console will copy all the tables from all source databases into the target database. Of course, this behavior can be changed. One can opt to specify a particular list of tables to copy, and these tables can each have their own specific customization parameters applied. More information on this is available in our documentation. If several source databases are used, instead of a single Source element, you should use Sources with an array of items.
ConsoleMode JSON files are easy to understand – and declarative. One can see all the customizations right away, as there is no need to flick through different screens to examine what has been applied.
This is especially valuable in a multi-user environment, where a colleague coming to the project can immediately grasp the requirements.
An additional benefit is that JSON project files can be put into the source control, for security and audit.
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.
A JSON job specification to use. A typical example would be:
Run Omni Loader in a distributed cluster mode. Omni Loader becomes a cluster orchestrator and awaits for agents to connect to it.
Listen for incoming connections. A typical example would be:
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.
In console mode and CI/CD workflows, you can activate Omni Loader even without firing up the GUI.
Ready to get started?
We support over 20 databases at this point and are very likely to support yours. Take a look at the whole list on our databases page.
Omni Loader easily migrates absolutely huge databases. Our competitors either require a lot of time-consuming setup time or the performance is not suitable for very large databases.
Please contact us and we will discuss your needs.
We will gladly organize a demo of Omni Loader for you. Please reach out by filling out the form at Spectral Core and provide your work email address (not an anonymous one). We can only work with you if your budget is at least $30,000 per year.
If you would like a demo of Full Convert, we can't accomodate that as Full Convert is a low-cost tool. Instead, please use its free trial to ensure it works for your specific needs.
Please write to sales@spectralcore.com.
At this time we do not offer phone support. With customers in 98 countries we've been doing customer support for 20 years and phone support does not work well for anyone. Instead, please use email to open a support ticket by writing to support@spectralcore.com. One of our developers will make sure your issue is taken care of.
For on-premises installation please contact us to obtain a license. Once you do, you will get native executables for Windows and Linux. Run as many agents as your license allows to scale to the perfromance levels you need.
Absolutely - that's the core functionality of Omni Loader.
CDC is available for Oracle, SQL Server, and MySQL/MariaDB source databases. All target databases automatically support data ingestion from CDC-enabled sources.