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.
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 object | Databricks target | Iceberg target |
|---|---|---|
| Tables | Delta tables | Iceberg tables |
| Views | Databricks SQL views | Views in your chosen engine |
| Functions | SQL or Python functions | Spark SQL functions |
| Stored procedures | Databricks SQL or PySpark | PySpark jobs |
| Cursors and loops | Set-based rewrites | Set-based rewrites |
| Dynamic SQL | Parameterized code, flagged for review | Parameterized code, flagged for review |
| Triggers | Pipeline steps or change data feed | Pipeline steps |
| SQL Agent jobs | Databricks Workflows | Your orchestrator, e.g. Airflow |
| Data | Bulk and incremental migration | Bulk 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 studiesPricing
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
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 An AI-powered supply chain planning software company, SQL Server to Delta Lake, self-service rollout. Definitions on the Methodology page.
- 2 Prices in USD as of the review date. Full terms on the Pricing page.
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.
Not sure which door? The scorecard takes ten minutes and tells you.