Commercial plans of Fabric Migration workload unlock additional functionality.

Code migration

When translating SQL code, it is crucial to test the code well. Even with the most careful translation, platform differences may cause change in behavior that affects your business logic. In free plan, you have full testing framework enabled - but you need to specify every test case yourself. Writing out appropriate procedure and function parameters one by one takes time.

In paid plans we SQL Tran uses its powerful static analysis engine to generate thousands of tests for you in mere seconds. It analyzes your code, samples the test database data and specifies appropriate parameters. It can create up to 20 tests per object at a time, which is plenty, and you can re-run generation of tests at any time if you wish to have even more than 20 tests per object. With this capability you can start with just an SQL script to create a project, and end up with a fully tested live target database in a very short time.

Data migration

Paid plans unlock a broad set of enterprise and cloud platforms as sources of modernization to Fabric Warehouse and Lakehouse:

• 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