Code and data migration

SQL Tran & Omni Loader in tandem

You can opt to create tables in Omni Loader and copy all the data without ever creating a code project in Fabric Migration workload. Omni Loader is perfectly capable of optimally completing the schema creation for tables, indexes, and foreign keys.

Another way is to create full schema in Fabric Migration workload, then use Omni Loader to ingest data into already existing tables. To do that, once you have created the live target database, proceed with creatin a Full Table Copy project in Omni Loader with exact same target database connection. To avoid recreating tables once more in Omni Loader, change the Table creation project option to Expect existing.

If this was useful,
our newsletter will be too.

Get monthly insights on data engineering, AI, and building critical infrastructure - direct from the Spectral Core team and CEO Damir Bulic.