SQL Server to Databricks and Fabric

SQL Server to Databricks and Fabric migration

The short answer

Novuz converts SQL Server tables, views, functions, stored procedures and SQL Agent jobs into Databricks, Microsoft Fabric or open Iceberg pipelines with fixed rules. Every object ships with a reconciliation report, and the software runs inside your environment.

Take the logic debt scorecard

Risks

What breaks in a SQL Server migration

These are the five problems we see most often in SQL Server estates.

  • Long T-SQL procedures use cursors, temp tables and row-by-row loops that perform badly when copied to Spark.
  • TRY/CATCH blocks and explicit transactions carry error handling that needs a different pattern on the target.
  • Dynamic SQL builds queries at run time, so static tools miss the real logic.
  • Collation, NULL handling and date functions differ between T-SQL and Spark SQL, which shifts results quietly.
  • Triggers, linked servers and cross-database queries hide dependencies that only show up at cutover.

Coverage

What Novuz converts

Final coverage is confirmed during the assessment.

SQL Server objectDatabricks targetIceberg target
TablesDelta tablesIceberg tables
ViewsDatabricks SQL viewsViews in your chosen engine
FunctionsSQL or Python functionsSpark SQL functions
Stored proceduresDatabricks SQL or PySparkPySpark jobs
Cursors and loopsSet-based rewritesSet-based rewrites
Dynamic SQLParameterized code, flagged for reviewParameterized code, flagged for review
TriggersPipeline steps or change data feedPipeline steps
SQL Agent jobsDatabricks WorkflowsYour orchestrator, e.g. Airflow
DataBulk and incremental migrationBulk and incremental migration

Worked example

What a typical estate looks like

An illustrative SQL Server estate at a regional health system. These figures are an example, not a customer result.

  • 3,000 stored procedures, of which 250 use dynamic SQL
  • 400 functions and 1,100 views
  • 6,500 tables across 25 databases
  • 420 SQL Agent jobs
  • Complexity split: 58% low, 30% medium, 12% high
  • Assessment output: a fixed price for the full estate and a recommended first domain of about 800 objects

Proof

SQL Server to an open table format

A Fortune 500 natural gas utility is modernizing its SQL Server estate to open Iceberg tables with Novuz running inside its own environment. An AI-powered supply chain planning software company is running a self-service SQL Server to Delta Lake rollout covering 8,000 workflows.¹

Read the case studies

Pricing

Pricing for SQL Server to Databricks and Fabric

Pricing follows object count and complexity, not hours. The price is the same whichever target you choose.

Estate assessment

$3,000. Three business days. Credited in full.2

First Domain

$25,000 to $40,000. 5 to 6 weeks on one domain of up to 1,500 components. Equivalence guarantee in writing.2

Full estate

Fixed from the assessment. Typically $40,000 to $200,000 for 1,500 to 10,000 objects, or an enterprise license for larger estates.2

See full pricing

Honest fit

Who should not choose Novuz

Novuz is not the right choice for estates under about 300 objects; for Oracle-only or mainframe estates; for teams with no target and no date inside 18 months; for buyers who want staff augmentation rather than software; or for organizations that cannot run software inside their environment or share code for an assessment.

FAQ

Frequently asked questions

  1. 1 An AI-powered supply chain planning software company, SQL Server to Delta Lake, self-service rollout. Definitions on the Methodology page.
  2. 2 Prices in USD as of the review date. Full terms on the Pricing page.

How we measure: Methodology

Last reviewed:

Find out what your logic debt is costing you.

Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.

Take the logic debt scorecard

Not sure which door? The scorecard takes ten minutes and tells you.

Scorecard