Migration guides
Move off legacy data platforms without losing trust in the numbers
Step-by-step guides for 42 migration paths, written by engineers: what to inventory, how each component maps, what breaks, and how to prove the results match.
To Databricks
Alteryx → Databricks
Alteryx to Databricks migration: moving analyst workflows to the lakehouse
How to migrate Alteryx Designer workflows and Alteryx Server schedules to Databricks: inventory tools from workflow XML, map Alteryx tools to Spark SQL, replace macros and predictive tools, and bring analysts along.
Azure Synapse → Databricks
Azure Synapse to Databricks migration: dedicated pools, Spark and pipelines
How to migrate Azure Synapse Analytics to Azure Databricks: dedicated SQL pools to Delta and Databricks SQL, T-SQL conversion, Synapse Spark notebooks, serverless views over ADLS, pipelines and Power BI.
BigQuery → Databricks
Google BigQuery to Databricks migration: a practical guide
How to migrate BigQuery to Databricks: exporting tables to Delta, converting GoogleSQL to Spark SQL (UNNEST, STRUCT, SAFE functions), partitioned and clustered tables, scheduled queries, BigQuery ML and Lakehouse Federation.
DataStage → Databricks
IBM DataStage to Databricks migration: converting jobs, stages and sequences
How to move IBM InfoSphere DataStage parallel jobs and sequences to Databricks: export and inventory, map each stage to Spark SQL and Delta, rebuild sequences as Lakeflow Jobs and reconcile.
Exadata → Databricks
Oracle Exadata to Databricks migration: replacing the hardware refresh
How to move a data warehouse off Oracle Exadata to Databricks before the next hardware refresh: what replaces Smart Scan, HCC and partitioning, moving tens of terabytes, and keeping OLTP workloads separate.
Greenplum → Databricks
Greenplum to Databricks migration: a practical guide
How to migrate a Greenplum MPP warehouse to Databricks: converting PostgreSQL-based SQL and PL/pgSQL, replacing DISTRIBUTED BY and append-optimized tables, gpfdist loads, MADlib analytics, and reconciliation.
Hadoop → Databricks
Hadoop to Databricks migration: moving HDFS, Hive, Spark and Oozie
How to migrate a Hadoop (Cloudera or Hortonworks) estate to Databricks: HDFS to cloud storage, Hive tables to Delta, Hive metastore and Ranger to Unity Catalog, Spark and Oozie jobs to Lakeflow Jobs.
Informatica → Databricks
Informatica PowerCenter to Databricks migration: a practical guide
How to move Informatica PowerCenter mappings, sessions and workflows to Databricks: export and inventory the repository, map each transformation to Spark SQL and Delta, rebuild workflows as Lakeflow Jobs, and reconcile every target before switching off the licence.
Netezza → Databricks
Netezza to Databricks migration: from appliance to lakehouse
How to migrate IBM Netezza to Databricks: converting NZSQL and NZPLSQL to Spark SQL, replacing distribution and organizing keys with liquid clustering, loading with Auto Loader, governance in Unity Catalog and cutover.
Oracle → Databricks
Oracle data warehouse to Databricks migration: a practical guide
Moving an Oracle data warehouse to Databricks: PL/SQL conversion, the Oracle behaviours that break results (empty strings, DATE, NUMBER), change data capture, parallel runs and licence decommissioning.
Pentaho → Databricks
How to convert Pentaho (PDI) jobs to Databricks: a step-by-step migration guide
Moving Pentaho Data Integration (Kettle) transformations and jobs to Databricks: how to inventory .ktr and .kjb files, map each PDI step to Spark SQL, Delta and Lakeflow, and prove the results match.
Redshift → Databricks
Amazon Redshift to Databricks migration: a practical guide
How to move Amazon Redshift to Databricks on AWS: unloading to S3 as Delta, Spectrum tables into Unity Catalog, converting SQL and procedures, Lakehouse Federation for a gradual cutover, and replacing WLM with SQL warehouses.
SAS → Databricks
SAS to Databricks migration: converting DATA steps, PROCs and macros
How to migrate SAS analytics and ETL to Databricks: inventory programs, convert DATA steps and PROC SQL to Spark SQL and PySpark, replace PROCs, macros and formats, revalidate models and retire SAS licences.
Snowflake → Databricks
Snowflake to Databricks migration: when and how to consolidate
How to move workloads from Snowflake to Databricks: deciding what to move, federating Snowflake into Unity Catalog, unloading to Delta, converting Snowflake SQL, Streams and Tasks, Snowpark and governance policies.
SQL Server → Databricks
SQL Server to Databricks migration: T-SQL conversion, collation and CDC
How to migrate a SQL Server data warehouse to Databricks: Lakebridge assessment and conversion, Lakeflow Connect CDC ingestion, case-insensitive collation versus Databricks defaults, T-SQL differences, SQL Agent jobs, SSIS and reconciliation.
SSIS → Databricks
SSIS to Databricks migration: how to convert SQL Server Integration Services packages
Moving SSIS packages to Databricks: inventory .dtsx files, map data flow components to Spark SQL and Delta, rebuild control flow and SQL Agent schedules as Lakeflow Jobs, and reconcile before cutover.
Talend → Databricks
Talend to Databricks migration: converting Talend jobs to Spark SQL and Lakeflow
How to migrate Talend Studio jobs, including Talend Big Data Spark jobs, to Databricks: inventory components, map tMap and other components to Spark SQL, rewrite tJava code, and replace contexts and scheduling with Lakeflow Jobs.
Teradata → Databricks
Teradata to Databricks migration: a wave-by-wave plan that avoids the big bang
How to move a Teradata estate to the Databricks lakehouse in waves (inventory, code conversion, parallel runs and decommissioning) without losing the business's trust in the numbers.
Vertica → Databricks
Vertica to Databricks migration: a practical guide
How to migrate a Vertica analytics warehouse to Databricks: exporting to Parquet, replacing projections and segmentation, flex tables, Vertica-specific SQL such as TIMESERIES, UDx and in-database ML, and reconciliation.
To Microsoft Fabric
Azure Synapse → Microsoft Fabric
Azure Synapse Analytics to Microsoft Fabric migration: a practical guide
How to move Azure Synapse dedicated SQL pools, pipelines, Spark pools and serverless SQL to Microsoft Fabric: Warehouse and Lakehouse targets, T-SQL differences, data movement and cutover.
DataStage → Microsoft Fabric
IBM DataStage to Microsoft Fabric migration: jobs, stages and sequences
How to migrate IBM DataStage parallel jobs and sequences to Microsoft Fabric: export and inventory, map stages to Spark notebooks, Warehouse SQL or Dataflow Gen2, and rebuild sequences as Data Factory pipelines.
Hadoop → Microsoft Fabric
Hadoop to Microsoft Fabric migration: HDFS, Hive and Spark to OneLake
How to migrate a Hadoop (Cloudera or Hortonworks) cluster to Microsoft Fabric: HDFS to OneLake, Hive tables to Lakehouse Delta tables, Spark jobs to Fabric Spark, Oozie to Data Factory, Kafka to Real-Time Intelligence.
Informatica → Microsoft Fabric
Informatica PowerCenter to Microsoft Fabric migration: a practical guide
How to move Informatica PowerCenter mappings and workflows to Microsoft Fabric: choosing Dataflow Gen2, Warehouse SQL or Spark notebooks per mapping, transformation mapping, pipelines for workflows, and reconciliation.
Oracle → Microsoft Fabric
Oracle to Microsoft Fabric migration: PL/SQL, data types and Power BI
How to migrate an Oracle data warehouse to Microsoft Fabric: Warehouse or Lakehouse, converting PL/SQL to T-SQL or Spark, empty strings and DATE semantics, change data capture, Power BI and cutover.
Snowflake → Microsoft Fabric
Snowflake to Microsoft Fabric migration: mirroring, T-SQL and what changes
How to move from Snowflake to Microsoft Fabric, or run both: mirroring and Iceberg interoperability, converting Snowflake SQL to Fabric Warehouse T-SQL, VARIANT, streams and tasks, Snowpark, security, and a domain-by-domain cutover.
SQL Server and SSIS → Microsoft Fabric
SQL Server and SSIS to Microsoft Fabric migration: a practical guide
How to move a SQL Server data warehouse and its SSIS packages to Microsoft Fabric: Warehouse or Lakehouse, T-SQL compatibility, rebuilding SSIS in Fabric Data Factory, Power BI on OneLake and cutover.
Talend → Microsoft Fabric
Talend to Microsoft Fabric migration: replacing Talend jobs with Fabric pipelines
How to move Talend Studio jobs to Microsoft Fabric: inventory components from job XML, choose Dataflow Gen2, Warehouse SQL or Spark notebooks, map tMap and other components, and replace contexts and schedules with Data Factory pipelines.
Teradata → Microsoft Fabric
Teradata to Microsoft Fabric migration: a practical guide
How to move a Teradata warehouse to Microsoft Fabric: Warehouse or Lakehouse, converting Teradata SQL to T-SQL, QUALIFY and case-sensitivity differences, BTEQ and FastLoad replacements, Power BI and cutover.
To Snowflake
Azure Synapse → Snowflake
Azure Synapse to Snowflake migration: dedicated pools, T-SQL and the collation trap
How to migrate Azure Synapse Analytics to Snowflake on Azure: dedicated SQL pool tables via ADLS and COPY INTO, SnowConvert for T-SQL, distributions and indexes, case-insensitive collation, workload management, pipelines, serverless views and Power BI.
BigQuery → Snowflake
Google BigQuery to Snowflake migration: a practical guide
How to migrate BigQuery to Snowflake: exporting to Cloud Storage and loading with COPY INTO, converting GoogleSQL (UNNEST, STRUCT, SAFE functions), partitioning and clustering, scheduled queries, authorized views and BigQuery ML.
Greenplum → Snowflake
Greenplum to Snowflake migration: a practical guide
How to migrate a Greenplum warehouse to Snowflake: PostgreSQL-dialect SQL conversion, DISTINCT ON and arrays, PL/pgSQL to Snowflake Scripting, replacing DISTRIBUTED BY and gpfdist, MADlib to Snowpark, and reconciliation.
Hadoop → Snowflake
Hadoop to Snowflake migration: moving Hive, Spark and HDFS data
How to migrate a Hadoop (Cloudera or Hortonworks) cluster to Snowflake: HDFS data to Snowflake or Iceberg tables, Hive SQL conversion, Spark jobs to SQL or Snowpark, Oozie to Tasks, Ranger to Snowflake access policies.
Informatica → Snowflake
Informatica PowerCenter to Snowflake migration: options and a practical plan
How to move Informatica PowerCenter ETL to Snowflake: keep Informatica and push down, or rebuild in dbt, Snowflake SQL and Snowpark. Transformation mapping, orchestration, CDC and reconciliation.
Netezza → Snowflake
Netezza to Snowflake migration: a practical guide
How to migrate IBM Netezza to Snowflake: inventory, converting NZSQL and NZPLSQL, replacing distribution keys and zone maps, loading with COPY INTO, parallel runs and switching off the appliance.
Oracle → Snowflake
Oracle to Snowflake migration: converting PL/SQL and avoiding the classic gotchas
How to move an Oracle data warehouse to Snowflake: PL/SQL to Snowflake Scripting, empty strings and DATE semantics, sequences, CONNECT BY, materialized views and triggers, change data capture and reconciliation.
Redshift → Snowflake
Amazon Redshift to Snowflake migration: a practical guide
How to migrate Amazon Redshift to Snowflake: SQL and stored procedure conversion, identifier case and VARCHAR length gotchas, DISTKEY and SORTKEY, WLM to warehouses, Spectrum, loading via S3 and reconciliation.
SAS → Snowflake
SAS to Snowflake migration: moving SAS analytics and ETL into Snowflake
How to migrate SAS workloads to Snowflake: pushing processing down with SAS/ACCESS as an interim step, converting PROC SQL and DATA steps to SQL and Snowpark, replacing macros, formats and PROCs, and validating models.
SQL Server → Snowflake
SQL Server to Snowflake migration: T-SQL conversion and the collation trap
How to migrate a SQL Server data warehouse to Snowflake: converting T-SQL procedures, case-insensitive collation versus case-sensitive Snowflake, data types, temp tables, SQL Agent jobs, SSIS and reconciliation.
SSIS → Snowflake
SSIS to Snowflake migration: replacing SSIS packages with ELT in Snowflake
How to move SQL Server Integration Services packages to Snowflake: land raw data, rebuild data flows as SQL and dbt, replace OLE DB Command with MERGE, Script Tasks with Snowpark, and SQL Agent with Snowflake Tasks.
Talend → Snowflake
Talend to Snowflake migration: replacing Talend jobs with dbt and Snowflake SQL
How to move Talend Studio jobs into Snowflake: inventory components, map tMap and other components to SQL, replace contexts and scheduling, handle tJava code, and reconcile before switching off Talend.
Teradata → Snowflake
Teradata to Snowflake migration: a practical guide
How to move a Teradata warehouse to Snowflake: inventory, SQL and BTEQ conversion, the behaviour differences that break reports, loading, parallel runs and decommissioning before the renewal.
Vertica → Snowflake
Vertica to Snowflake migration: a practical guide
How to migrate Vertica to Snowflake: exporting to Parquet and loading with COPY INTO, replacing projections, flex tables to VARIANT, rewriting TIMESERIES with time spines and ASOF JOIN, UDx and in-database ML.
Migrating from something else?
Cloud data migration
Legacy warehouse to lakehouse, with parallel-run validation. We also migrate Sybase and Ab Initio.
Frequently asked questions
How long does a data platform migration take?
It depends on the number of objects, jobs and consumers, not on data volume. A first business domain typically reaches production a few weeks after the inventory; a full estate moves in parallel waves over several months, each with a dated decommission milestone.
Can legacy code be converted automatically?
Much of it. Conversion tools translate most SQL, stored procedures and standard ETL steps. Procedural code, scripted transformations and platform-specific behaviour still need rewriting and testing, and every converted table should be reconciled against the old system before cutover.
Which target platform should we choose?
Databricks suits engineering-heavy, data science and AI workloads; Snowflake suits SQL-first analytics and data sharing; Microsoft Fabric suits organizations standardized on Microsoft and Power BI. Many estates combine them. Try our platform chooser, or let a Data Platform Assessment compare them on your workloads and costs.
Have 30 minutes? Get a senior architect’s view of your data platform.
No sales deck. You talk to the engineer who would lead the work.
Book an architecture review