SQL Tran code scope
Four documented T-SQL sources
- Azure SQL Database
- Azure SQL Managed Instance (SQL MI)
- SQL Server
- Synapse Analytics Dedicated SQL Pool
Data and code. Into Fabric.
One workload that combines SQL Tran and Omni Loader to cover data and code migrations from on-premises and cloud databases to Microsoft Fabric.
Choose your migration path
Separate code scope from data scope before you plan the move.
Fabric Migration combines SQL Tran and Omni Loader, but the supported sources differ by workload. Use the scope below to start with the path your team actually needs.
Code: SQL translation into Fabric Warehouse.
Data: table and data movement through Omni Loader.
Omni Loader data scope
Free and Premium source sets
The free path currently lists 5 sources. Premium adds 35 additional source entries shown on this page.
Azure SQL DatabaseAzure SQL Managed Instance (SQL MI)SQL ServerSynapse Analytics Dedicated SQL PoolSynapse SQL Serverless
Review data migration Before you start: confirm the source is in the relevant list, decide whether you are moving code, data, or both, and validate the result in the Fabric environment before treating the migration as complete.
Why Fabric Migration
Spectral Core Fabric Migration is a native Microsoft Fabric workload that helps organizations migrate both data and database code to Fabric through one guided experience. It combines Omni Loader for high-performance data migration with SQL Tran for database code migration, including schemas, objects, SQL, and stored procedures.
Unified data & code migration
Migrate both data and database code through a single, streamlined workflow, eliminating the need for separate tools or parallel processes.
End-to-end guided experience
Move from your existing systems to Fabric with a clear, guided journey that ensures control, visibility, and reduced migration risk.
Automated schema & object conversion
Convert schemas, database objects, SQL, and stored procedures into Fabric-compatible formats, with review where source and target behavior differ.
High-performance data transfer
Move large datasets through the Omni Loader workflow, then validate throughput and downtime assumptions in your own Fabric environment.
Database code migration
More than a converter, it is a translation IDE: see your source and Fabric Warehouse DDL side by side, jump to any object with Ctrl+K, trace read and write lineage, and let SQL Tran auto-generate behavioral tests so you can prove the Fabric version behaves like the original.
Target emulations and rewrites
SQL Tran includes targeted emulations and rewrites for Synapse-specific behavior when migrating to Fabric Warehouse.
Data migration
Omni Loader moves your data into Fabric. Free plan includes core Microsoft sources; Premium adds many database sources.
Flexible plans for any data migration
Start for free with essential database support, then upgrade to Premium to access 34 data sources, enterprise systems, and advanced migration capabilities, all in one tool.
Free plan
Available at no cost for data migration into Fabric.
✓ Azure SQL Database
✓ Azure SQL Managed Instance (SQL MI)
✓ SQL Server
✓ Synapse Analytics Dedicated SQL Pool
✓ Synapse SQL Serverless
Unlock advanced features
Full set of sources for data migration (includes all Free plan sources plus the following).
✓ Amazon RDS
✓ Amazon Redshift
✓ Analytics Platform System
✓ Apache Parquet
✓ Azure SQL Database
✓ Azure SQL Managed Instance (SQL MI)
✓ CockroachDB
✓ CSV
✓ Databricks
✓ DB2 for i
✓ DB2 LUW
✓ DB2 z/OS
✓ Exadata
✓ Fabric Lakehouse
✓ Fabric SQL Database
✓ Fabric Warehouse
✓ Google AlloyDB
✓ Google BigQuery
✓ Google Spanner
✓ Greenplum
✓ MariaDB
✓ MySQL
✓ Netezza
✓ NuoDB
✓ ODBC
✓ Oracle
✓ PostgreSQL
✓ SAP Adaptive Server Enterprise
✓ Snowflake
✓ SQL Server
✓ Synapse Analytics Dedicated SQL Pool
✓ Synapse SQL Serverless
✓ Teradata
✓ Vertica
✓ Yellowbrick
Need more sources? See Plans & Pricing
Unlock 34 source databases for data migration into Microsoft Fabric, including Amazon RDS, Oracle, Snowflake, Databricks, and more.
Ready to migrate to Microsoft Fabric ?
Use SQL Tran for code and Omni Loader for data, one workload for your Fabric migration.