SQL Tran Docs
  • Overview
    • About
    • Getting started
    • Object lifecycle
    • Why is there no AI inside?
    • Performance considerations
    • Security considerations
    • Assessment
    • Unlocking projects
    • Interface walk-through
    • Translation scenarios
    • Prerequisites for Azure Marketplace deployment
  • Emulation scenarios
    • Emulation in SQL Tran
    • SQL Server to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Cursors
        • Basic cursor loop
        • Cursor types
        • Fetch direction modes
        • Cursors in control flow
        • Nested cursors
        • Data modification cursors
        • Multiple cursors
        • Subqueries and filtering
      • Named procedure parameters
      • Result set limiting
      • MERGE statements
      • Computed columns
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Sequences
      • Unsupported system features
    • Synapse Analytics to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Named procedure parameters
      • Result set limiting
      • MERGE statements
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Materialized views
      • Create table as select (CTAS)
      • Unsupported system features
    • SQL Server to Synapse Analytics
    • Oracle to PostgreSQL
  • Project wizard
    • Source database
    • Target database
    • Wrapping up
  • Projects
    • Project list
    • Overview
    • Workspace
    • Reports
    • Tests
    • Scratch pad
    • Settings
      • Project name
      • Mapping
      • Database connections
    • Navigation
    • Object complexity
    • Static analysis
    • Translation errors
    • Exporting and importing projects
  • Workspace
    • Object tree
    • Data lineage
    • Code
    • Actions
      • Overriding source
      • Overriding target
      • Ignoring objects
  • Tests
    • Workflow
    • Configure SQL Tran
    • Connecting to databases
      • Fabric Warehouse
      • Synapse Dedicated SQL Pool
      • Azure SQL Database, Azure SQL Managed Instance, Microsoft SQL Server
    • Tables
    • Views
    • Procedures
    • Functions
    • Triggers
    • Performance tests
  • Scripter
    • About
    • Supported databases
    • SQL Server
    • Azure SQL
    • Synapse Dedicated Pool
    • Oracle
    • PostgreSQL
    • MySQL
  • Microsoft training - SQL Tran
    • Introduction
    • Licensing plans
    • Deploying and activating
    • Creating a new project
    • Exploring the "Overview" screen
    • Inside the "Workspace" screen
Powered by GitBook
On this page
  • Emulations
  • Limitations
  1. Emulation scenarios

Synapse Analytics to Fabric Warehouse

Synapse Analytics migration to Fabric Warehouse means modernization to a new architecture, one working with open Parquet format.

SQL Tran emulates the functionality no longer relevant in Fabric (like materialized views), rewrites the code for constructs not yet available in Fabric (like MERGE statements) and even provides extensive rewrites for identity columns and temporary tables usage, where Fabric has yet to release support but what one can expect to find in every single database to be migrated.


Emulations

  • External tables are transformed into standard tables

  • Materialized views are transformed into standard views

  • MERGE statements are transformed into equivalent combination of DELETE, UPDATE, and INSERT statements

  • Identity columns are transformed into standard columns and all statements inserting data into tables are modified to insert monotonously-increasing values into the now standard (big)int columns

  • Database-wide name references are rewritten so that case-insensitive code won't break in case-sensitive Fabric Warehouse

  • SET ROWCOUNT is deleted and statements after it are transformed to achieve the same effect. In cases where static analysis cannot determine correct transformation, a limitation is reported instead.

  • Named EXEC parameters are refactored to positional parameters


Limitations

  • Invalid schema name (containing \ or /)

  • ALTER TABLE (ADD/DROP and all ALTER COLUMN except ADD/DROP MASKED)

  • CREATE ROLE

  • CREATE USER

  • FOR BROWSE/XML/JSON

  • SET TRANSACTION ISOLATION LEVEL

  • SET ROWCOUNT. Note that in cases where we can emulate it the error is not reported.

  • SET RESULT_SET_CACHING

  • SP_SHOWSPACEUSED

  • MULTI-COLUMN STATISTIC

  • RECURSIVE QUERY

  • PREDICT

  • $PARTITION

  • Unsupported functions - the ones returning errors in Fabric and some that work but return invalid value

  • XML methods

  • system views (sys.sequences, sys.dm_pdw_*)

PreviousUnsupported system featuresNextData types

Last updated 15 days ago