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.

‍

‍

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.