Products
Services
Resources
Company
Blog
Login
SQL Tran
Overview
Scenarios
Technology
Resources
Get in Touch
Go To App
☰
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
Result set limiting
Computed columns
Temporary tables
External tables
Identity columns
Default values
Sequences
Table variables
Multi-statement table-valued functions
Unsupported system features
Synapse Analytics to Fabric Warehouse
Data types
Case sensitivity
Named procedure parameters
Result set limiting
Temporary tables
External tables
Identity columns
Default values
Materialized views
Create table as select (CTAS)
Limitation detection
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
Understanding the Target screen
Code translation and emulations
Using the Reports screen
Testing with SQL Tran
Connecting to staging databases
Actions menu in testing
Creating the target staging schema
Verifying schema in the staging databases
Refreshing project metadata
Schema verification after refresh
Using the Actions dropdown
Fixing translation errors
Examining the Tests screen
Working with the Scratch pad
Microsoft training - Omni Loader
Page 1
Microsoft training - Omni Loader
Page 1
Previous
Working with the Scratch pad
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
Result set limiting
Computed columns
Temporary tables
External tables
Identity columns
Default values
Sequences
Table variables
Multi-statement table-valued functions
Unsupported system features
Synapse Analytics to Fabric Warehouse
Data types
Case sensitivity
Named procedure parameters
Result set limiting
Temporary tables
External tables
Identity columns
Default values
Materialized views
Create table as select (CTAS)
Limitation detection
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
Understanding the Target screen
Code translation and emulations
Using the Reports screen
Testing with SQL Tran
Connecting to staging databases
Actions menu in testing
Creating the target staging schema
Verifying schema in the staging databases
Refreshing project metadata
Schema verification after refresh
Using the Actions dropdown
Fixing translation errors
Examining the Tests screen
Working with the Scratch pad
Microsoft training - Omni Loader
Page 1