Feb 13, 2020 3:00:00 AM by Quest Software
In our blog, “An introduction to 8 ApexSQL tools,” we introduced our Toad World® readers a new member in the Quest® family of database tools, ApexSQL. While ApexSQL has 29 (and growing) DBA and developer tools, we narrowed our focus to 8 tools that we thought would be of interest. This year, we’ll expand on that introduction and provide a helpful accompanying blog series for each.
As DBA and developer roles continue to expand, and database environments continue to evolve, we understand you need reliable tools. ApexSQL tools are built for the Microsoft SQL Server environment. With its proven SQL expertise and solutions, ApexSQL provides competitive SQL solutions for database auditing, recovery, change management, development and documentation.
Data comparison and synchronization between databases is often tasked these days and a proper tool is needed to handle that job without issues and/or errors. ApexSQL Data Diff is that kind of a tool. It can compare and synchronize SQL Server data between databases and database backups, and it can also compare data under script folders and source control projects.
So what's the main difference between Diff and Data Diff? The main difference between ApexSQL Diff and ApexSQL Data Diff is that ApexSQL Diff compares and synchronizes schemas (structure), while ApexSQL Data Diff compares and synchronizes data.
It also supports comparison and synchronization of SQL Azure Databases, Amazon RDS for SQL Server, CLI, creating automation scripts (batch and PowerShell scripts), and executable installation packages.
It can automate and schedule database data migrations, propagate data changes from one environment to another, identify and repair lost and/or damaged data, perform row level recovery from SQL backups without restoring.
In case something goes wrong, ApexSQL Data Diff can reverse any changes made by automatically creating a backup prior to database synchronization, or a rollback script.
With this tool you'll be able to create sophisticated reports to document the differences between your data sources and schedule your migration unattended, using the Command Line Interface and automation scripts.
The provided articles will help you better understand the tool itself and how to quickly compare data between different SQL Servers and data source, filtering data, along with automation:
Automate and run unattended
With ApexSQL Data Diff, there is no need for manual comparison and synchronization of data, as the complete process can be automated and run unattended, while you can sit back and just check the created output files once it’s done.
Learn more about ApexSQL Data Diff.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Written by Quest Software