Introduction
Welcome to this training guide on SQL Tran, developed by Spectral Core.
This guide walks you through the complete migration process from Synapse Dedicated SQL Pool to Microsoft Fabric Warehouse, covering every step from deployment to post-migration testing.
Whether you are a hands-on database engineer or an architect overseeing a cloud migration initiative, this document will help you understand and operate SQL Tran effectively.
If you prefer a visual format, a training video is also available. This guide covers the same goals as the video, helping you understand and use SQL Tran effectively, but in a written step-by-step format you can refer to at your own pace.
Who we are
Spectral Core is a trusted software company with over 20 years of expertise in database migration solutions.
We offer two complementary tools:
Omni Loader – for high-speed, scalable data migration
SQL Tran – for SQL code translation, schema generation, and testing
These tools are designed to work independently or together, depending on the scope of your migration project.
In the sections that follow, we’ll provide a concise overview of both tools, highlighting their key features and how they support different aspects of the database migration process.
Omni Loader: enterprise-grade data migration
Omni Loader is distributed as a standalone binary application available for both Windows and Linux. It is capable of migrating hundreds of terabytes of data efficiently—even from a single machine.
Security-first design: Omni Loader runs entirely in your infrastructure.
Simple setup: No installation required—just unpack and run.
Performance at scale: Optimized for parallel processing and minimal resource consumption.
Data flows directly from the source database into Omni Loader and then into Microsoft Fabric Warehouse, ensuring minimal latency and complete data control.
SQL Tran: code translation with zero compromise
SQL Tran is deployed via the Azure Marketplace and runs entirely within your Azure tenant. Spectral Core has no access to your environment, data, or metadata. This architecture provides complete isolation and enterprise-grade security:
No data or metadata access
No co-administrator privileges
No external communication with Spectral Core
SQL Tran requires only a SQL script as input to perform its translation tasks. For users who grant database access, it unlocks more advanced features, including:
Target schema creation directly from the application
Automated test generation for procedures, views, and functions
Table data comparison between source and target environments
Supported migration scenarios
SQL Tran currently supports the following end-to-end migration paths:
Synapse Analytics → Fabric Warehouse
Azure SQL → Fabric Warehouse
SQL Server → Fabric Warehouse
Oracle → PostgreSQL (available in private preview)
Additional support is coming soon for the following scenarios:
Oracle → Fabric Warehouse
Oracle → Snowflake
Each scenario is supported by purpose-built translation and emulation logic that adapts your existing codebase to the architecture and syntax of your chosen target platform.
Last updated