SQL Server to Fabric DW

Migrate SQL Server workloads to Microsoft Fabric Warehouse — without losing behavior, logic, or control.

Not just syntax conversion but a full behavioral preservation

SQL Server to Fabric Warehouse migrations fail when teams underestimate how different the distributed, cloud-native Fabric execution environment is from traditional SQL Server. SQL Tran was built specifically to bridge that gap. It understands T-SQL semantics at scale and translates them into Fabric Warehouse–compatible equivalents automatically, repeatably, and safely.

The Reality

SQL Server databases are not just SQL. They are built of:

Tables, views, stored procedures, functions, and triggers
Cursors and sequences
Identity columns and table variables
Complex data types and transient constructs

These features reflect decades of business logic embedded in database code. Microsoft Fabric Warehouse is powerful but it is very different from SQL Server. It is a distributed analytics engine with a constrained SQL surface and distributed execution model. Manual rewrites inevitably introduce regressions, inconsistencies, delays, and risk. Most tools stop at surface-level translations, and that’s why migrations are still high-risk and expensive.

‍

How SQL Tran Bridges the Gap

SQL Tran was designed for complex SQL Server codebases. It uses deep static analysis and a purpose-built emulation layer to adapt SQL Server semantics to Fabric Warehouse’s distributed architecture. Where direct feature equivalents do not exist, SQL Tran reconstructs behavior using alternative, Fabric-compatible SQL patterns preserving original business logic as closely as possible.

SQL Tran doesn’t just rewrite logic. It transforms it into idiomatic Fabric Warehouse SQL code constructs that behave the same or with explicit, traceable differences.

Lorem ipsum dolor sit amet

What SQL Tran Handles Automatically

SQL Tran parses and analyzes every object, building a detailed semantic model.

Screenshot of the Omni Loaders data merger progress and streaming load.

Lorem ipsum dolor sit amet

Sisyphus

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris imperdiet egestas blandit. Suspendisse rhoncus congue lorem ut malesuada.

Candice Doe

Product Manager, Sisyphus

Selected Emulations and Feature Adaptations

SQL Tran includes targeted emulations and rewrites for SQL Server–specific behavior:

Core constructs:

{
  "SqlServer": {
    "Server": "R12",
    "Database": "AdventureWorks2017",
    "AuthenticationType": "SqlServer",  // Windows|SqlServer
    "Username": "sa",
    "Password": "test"
  }
}

{
  "Oracle": {
    "ConnectionType": "Direct", // Direct|OracleClient
    "Server": "{{server ip, or empty if localhost}}",
    "Port": 11522,
    "Sid": "{{sid}}", // or "ServiceName": "{{service name}}",
    "Username": "sys",
    "Password": "{{password}}",
    "Role": "SysDBA"  // Default|SysDBA|SysOPER
  }
}

{
  "Synapse": {
    "Server": "{{yourserver}}.database.windows.net,
    "Database": "{{database name}}",
    "Username": "{{user}}",
    "Password": "{{password}}",
    "AuthenticationType": "sqlserver",
    "StorageType": "adlsv2",  // Local|AzureBlob|ADLSv2
    "StorageFormat": "parquet", // CSV|Parquet
    "StorageCompression": "snappy", // None|Snappy|GZip
    "ConnectionString": "{{conn string from storage explorer}}",
    "Container": "{{container}}",
    "ContainerDirectory": "{{directory name in the container}}"
  }
}

{
  "PostgreSQL": {
    "Server": "localhost",
    "Port": 5432,
    "Database": "{{db name}}",
    "Username": "postgres",
    "Password": "{{password}}"
  }
}

Lorem ipsum dolor sit amet

Rich Logic & Control Flow

Cursors

Fabric Warehouse doesn’t support T-SQL cursors. SQL Tran materializes cursor result sets into temporary tables and rewrites loops into deterministic, row-by-row logic compatible with distributed execution.

Result set limiting

Constructs like SET ROWCOUNT are transformed into equivalent TOP clauses.

Unsupported or Limited Features

Some SQL Server constructs cannot be fully emulated and are flagged with diagnostic annotations:

System-level features (e.g., sp_addrolemember, DBCC commands) and certain catalog views
Full-text search and XML methods
Server configuration and role management commands
In these cases, SQL Tran preserves the original code structure and annotates it for review and optional manual adjustment.

Lorem ipsum dolor sit amet

Translation with Intent

Thanks to super-fast, fully custom parsers, translation of even large codebases is practically instant. Millions of lines of T-SQL can be analyzed and translated in seconds. SQL Tran does more than rewrite: it transforms SQL Server logic into constructs that behave reliably in Fabric Warehouse’s distributed system.

Assessment and Reporting

Assessment is instant and detailed. SQL Tran produces a complete translation report showing:

All detected issues and incompatibilities

Emulations applied and why

Optimization opportunities

Deep statistics on object coverage and translation quality

This is the assessment you want before embarking on a migration. It is actually created by running a full translation behind the scenes and exposing encountered issues and detailed statistics.

Automated Testing

SQL Tran’s powerful testing framework is the ultimate project enabler, even when you only have SQL scripts:

Validate that functions return equivalent results
Verify that procedures affect tables identically
Generate synthetic test data tailored to source and target schemas
Detect edge-case and emulation differences automatically

Trust is earned, not assumed.

screenshot of workspace overview display

Migrations Available Now

See SQL Tran in Action

Talk to a Migration Architect

Assess Your Fabric Migration

SQL Server to Fabric DW

The Reality

How SQL Tran Bridges the Gap

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris imperdiet egestas blandit. Suspendisse rhoncus congue lorem ut malesuada.

Selected Emulations and Feature Adaptations

Core constructs:

Cursors

Result set limiting

Unsupported or Limited Features

Some SQL Server constructs cannot be fully emulated and are flagged with diagnostic annotations:

Assessment and Reporting

All detected issues and incompatibilities

Emulations applied and why

Optimization opportunities

Deep statistics on object coverage and translation quality

Automated Testing

Migrations Available Now

SOLUTIONS

SUPPORT

COMPANY

LEGAL