SQL Tran launch!

Damir Bulic -

After many years in development, SQL Tran, a complete game-changer for database migration, is here. This is an end-to-end solution for SQL translation, capable of easily handling even the most complex codebases.

There is no comparable offering on the market today:

  • Complete translation, which includes parsing and full static analysis, of several million lines of code is done in mere seconds. This is some two orders of magnitude faster than existing solutions on the market.
  • Static analysis instantly exposes broken code, broken references, and code constructs we cannot automatically translate. Bonus - full data lineage is instantly accessible.
  • Static analysis is used to inform our translator so target code is written in an idiomatic way and is maintainable and readable
  • The deployment is completely secure. SQL Tran is deployed to customer's own tenant from Azure Marketplace in just a few minutes.
  • Assessment is done in a pretty unique way - we perform a complete translation, then expose the statistics, translation success information, and list of issues remaining! It costs just $0.7 per hour per user (plus some Azure resources) but is so fast it's basically free.
  • Pricing is per usage and is displayed right within the UI. If you are happy with the assessment, paying right there in the UI unlocks a full project instantly.
  • Target database can be created manually (just download the ready to run target database script), or automatically. Setting up database connection allows a full target creation with a single click.
  • There is a full testing framework available! Providing staging source and target database connections is enough. SQL Tran will ensure that translated views return exact same data, and that translated procedures and functions implement the exact business logic as in the source database.

All of this comes with unmatched speed in parsing and translation. It is literally hundreds of times faster than existing solutions. But, even more importantly, it comes with extremely high accuracy and fantastic ease of use. SQL Tran is designed as an easy to use full IDE for SQL translation.

Our early-access customers use this on databases with many thousand objects and hundreds of thousands lines of code. A mid-size database is fully translated in milliseconds!

Scenarios covered today for production workloads:

  • SQL Server to Fabric Warehouse
  • SQL Server to Synapse Analytics
  • Synapse Analytics to Fabric Warehouse

More scenarios are coming very, very soon...

Product website is https://sqltran.com/.

SQL Tran is available on Azure Marketplace!