Videos

An extensive collection of video tutorials that provide step-by-step instructions on how to use Omni Loader for data migration. The tutorials cover various topics such as setting up the software, configuring migration, partitioning data, propagating name changes, and more.

Understand Omni Loader

Running an agent on a different machine is no more complex than copying binaries to the new machine and running a single executable file.

Introduction to Omni Loader

Omni Loader is a powerful, modern and easy-to-use database migration engine that allows you to move hundreds of terabytes of data with minimal effort. Developed over the past 20 years, it was designed to overcome the limitations and challenges of legacy solutions. With Omni Loader, you no longer need to spend hours or days setting up software, as it is ready to run out of the box with no customization required. It's incredibly fast, requires no setup and is fully self-tuning, meaning it works optimally right away. Additionally, it's horizontally scalable, meaning it's performance fully depends on the number of machines in the cluster. It also can handle multiple source databases in a single project and none of them have to be the same type. This saves time, money and resources. With Omni Loader, migrating data is no longer a hassle.

Copying SQL Server to PostgreSQL

How to easily and efficiently copy data from SQL Server to PostgreSQL using our powerful, modern and easy-to-use database migration engine. The tutorial covers the basics of setting up the software, configuring the migration and executing the data transfer.

Ingesting data from SQL Server into Synapse Analytics

The introduction to using Omni Loader for data ingestion from SQL Server to Microsoft Synapse Analytics (formerly known as Azure SQL Data Warehouse). The tutorial covers the basics of setting up the software, configuring the migration, and executing the ingestion of data.

Extensive Mapping Customizations

An in-depth look at how to use Omni Loader to customize data during migration process. It covers various advanced features of Omni Loader that allow you to customize the mapping of data between the source and target databases. The tutorial will show you how to configure the mapping according to the specific needs of your project, including mapping of different data types, handling of null values, and more. The tutorial will also cover best practices for customizing the mapping, as well as tips and tricks for ensuring a successful migration.

Distributed Data Migration Cluster

The video tutorial titled "Distributed Data Migration Cluster" is an in-depth look at how to use Omni Loader to migrate data in a distributed cluster environment. The tutorial covers the setup and configuration of a distributed data migration cluster using Omni Loader, including how to optimize performance and scalability by utilizing multiple machines in a cluster. The tutorial will walk you through the process step-by-step, making it easy for you to follow along and implement a distributed data migration using Omni Loader.

Console Mode

An introduction to using the console mode of Omni Loader. It covers the setup and configuration of the console mode, as well as how to use it to migrate data. It also covers best practices for using the console mode and how to optimize performance and scalability. The tutorial will walk you through the process step-by-step, making it easy for you to follow along and implement a data migration using the console mode of Omni Loader.

Partitioning Data On The Fly

An in-depth look at how to use Omni Loader to partition data during migration process. It covers various advanced features of Omni Loader that allow you to partition data on the fly while migrating between the source and target databases. The tutorial will show you how to configure partitioning according to the specific needs of your project, including partitioning by data size, handling of null values, and more. The tutorial will also cover best practices for partitioning data, as well as tips and tricks for ensuring a successful migration.

Propagating Name Changes Throughout the Business Logic

An in-depth look at how to use Omni Loader to propagate name changes throughout the business logic during migration process. It covers various advanced features of Omni Loader that allow you to propagate name changes across different database objects like tables, columns, views and procedures, while migrating between the source and target databases. The tutorial will show you how to configure the propagation according to the specific needs of your project and how to handle different scenarios like renaming a column or a table. The tutorial will also cover best practices for propagating name changes and how to avoid common pitfalls and errors.

Save time, increase efficiency.

Ready to get started?