Stedman SQL Podcast: Unveiling the New Schema Drift
This week on the Stedman SQL Podcast, Steve Stedman takes us through an exciting deep dive into the latest release of Database Health Monitor, spotlighting major enhancements to its Schema Drift tool. If you’re a database professional or enthusiast, this episode is one you won’t want to miss!
A Brief History of Schema Drift
First introduced in 2015 by Stedman Solutions, Schema Drift has been a game-changer for database administrators. This powerful tool enables users to compare schema objects—think tables, triggers, stored procedures, and more—across different databases. However, earlier versions relied on SQL Server Management Objects (SMO), which presented some challenges over time.
The 2024 Rewrite: Faster, Stronger, SMO-Free
In 2024, Steve and his team took Schema Drift back to the drawing board, completely rewriting it to eliminate its dependency on SMO. The result? A more stable, lightning-fast tool that’s better equipped to handle the demands of modern database management. In this episode, Steve walks us step-by-step through the revamped Schema Drift, showcasing its ability to:
- Detect differences between database schemas with precision
- Facilitate seamless object migration between databases
- Export comparison results to Excel—perfect for client presentations or documentation
Why You’ll Love This Episode
Steve’s demonstration highlights Schema Drift‘s practical applications, making it clear why this tool is a must-have for DBAs. Whether you’re troubleshooting discrepancies, managing database versions, or preparing reports, Schema Drift simplifies the process. Plus, it’s available for free as part of Database Health Monitor or as a standalone download at Schemadrift.com.
Watch the Podcast Now
Ready to see Schema Drift in action? Tune into this instructional episode of the Stedman SQL Podcast below. Steve’s clear, step-by-step guidance will leave you equipped to leverage this tool in your own database environment.
Don’t miss out—watch now and discover how Schema Drift can elevate your database management game!