Jan 30, 2020 3:00:00 AM by Quest Software
Last month 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.
Developers often need to compare database schemas, review and synchronize changes, and achieve that without issues and/or errors. ApexSQL Diff is a tool that can help in that process, as it can compare and synchronize SQL Server schemas between databases and database backups, but it can also compare schemas under script folders and source control projects, along with ApexSQL snapshots.
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 migrations, propagate schema changes from one environment to another, identify and repair lost and/or damaged objects, perform object level recovery from SQL backups without restoring.
In case something goes wrong, ApexSQL Diff can reverse any changes made by automatically creating a backup prior to database synchronization, a rollback script, or an ApexSQL snapshot.
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.
With ApexSQL Diff, there is no need for manual comparison and synchronization of schemas, 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.
Visit the ApexSQL Diff product page and learn how you can compare SQL schemas from databases, backups, scripts and source control.
The following articles will help you better understand the tool itself and how to quickly compare schemas between different SQL Servers and data source, filtering objects, along with automation:
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