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
      • External tables
      • Materialized views
      • Identity columns
      • Unsupported system objects
    • Synapse Analytics to Fabric Warehouse
      • Emulations
      • Limitations
    • 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
Powered by GitBook
On this page
  1. Overview

Getting started

PreviousAboutNextObject lifecycle

Last updated 1 month ago

Once you deploy the SQL Tran application on , SQL Tran will be deployed to your Azure tenant, ensuring complete isolation of your data. Nobody can access it but you and the users you give access to. The user who deployed SQL Tran becomes a super-admin and can invite other users.

Make sure to have Azure quota in the region where you are deploying SQL Tran! Please see Prerequisites for Azure Marketplace deployment

Once you deploy your application, we wil immediately send you an email with your private application URL. Please navigate to that email URL before continuing.

If you have deployed a BYOL plan of SQL Tran, you will be asked for your activation code before you are allowed to continue using the application. BYOL plan is not a pay-as-you-go plan and requires your organization to have pre-purchased licenses separately.

Creating your first project

To get started, click the New project button, select your source database type, and you can immediately upload your source database script.

If you don't have the script ready, use our Scripter tool to quickly extract code from your live database. Scripter doesn't send anything to Spectral Core and instead simply writes a file to your disk. You can upload that file to SQL Tran.

If the email didn't arrive to the address you specified in Azure Portal when deploying the app, please check your company policies and spam folder. The email is sent from "Spectral Core Team" () address.

support@spectralcore.com
Azure Marketplace
Basic workflow
Initially, there is a greeting screen. Once you create your first project, you will see your list of projects.
We will select SQL Server here.
SQL Tran supports SQL, ZIP, and DACPAC files for upload.