Announcing support for Microsoft SQL Server in Datafold

We’re excited to announce support for Microsoft SQL Server in Datafold, so you can perform data diffs across and within your SQL Server instance.

Why support SQL Server?

Over the past year, we’ve talked to countless data teams who are in the process of transitioning from their legacy/on-prem databases to more modern data infrastructure built on top of Modern Data Stack and cloud technologies. We’ve also heard the consistent pain points that come with undergoing a migration like this—technical difficulties validating a migration, planning and identifying migration assets, and earning stakeholder sign-off—just to name a few.

Datafold is proud to support a migration toolkit that enables teams to move to a modern data stack faster (and with greater confidence). These features include:

  • Cross-Database Diffing: Run data diffs across SQL databases to validate the parity of data fast (seconds/minutes), at any scale. Receive value-level differences across tables, so your team can identify and resolve potential migration issues quickly.
  • SQL Translation: Translate your SQL queries with the click of a button. Spend 0 time on rewriting SQL and looking up SQL dialect nuances between SQL Server and your new database.

With our new Microsoft SQL Server integration, your team can validate a migration from SQL Server to a newer system faster with our efficient cross-database diffing.

Datafold’s efficient data diffing algorithm works at scale, so your team can validate parity of tables with millions or billions of rows in fast—work that would normally take your team days to complete.

Value-level differences of a DIM_ORGS table across SQL Server and Snowflake

In addition, if your team is conducting ongoing data replication between SQL Server and another database, Datafold’s cross-database diffing and monitoring capabilities can help ensure continuous data parity. This provides data teams next-level visibility into their data reconciliation pipelines.

How to get started

If your team is undergoing a migration off of Microsoft SQL Server, or wants to gain visibility into the performance of your data replication efforts, make sure to reach out to our team today to learn more about how cross-database diffing can help you gain data quality peace of mind.

Datafold is the fastest way to validate dbt model changes during development, deployment & migrations. Datafold allows data engineers to audit their work in minutes without writing tests or custom queries. Integrated into CI, Datafold enables data teams to deploy with full confidence, ship faster, and leave tedious QA and firefighting behind.

Datafold is the fastest way to test dbt code changes