Founded in 1997, now Devart is one of the leading software development company for professionals worldwide involved in IT. It provides database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. More than a hundred of professionals make efforts to ensure that our products and services are among the best in the world.
dbForge Schema Compare is a comprehensive tool that gives an overview of the differences between several schemas. With this tool, you can generate SQL scripts to update one database with data from another one, automate sync tasks, fix errors on the go, and deploy your database to such cloud systems as Percona, Oracle MySQL Cloud, Amazon RDS, and Alibaba Cloud.
Key features:
Schema sync. Generate synchronization scripts with a preview changes for any schema object, customize its output, perform structure sync, and get warnings on possible data losses or errors during synchronization with this functionality.
MySQL backup and restore. Have database backup and restore wizards at your hand whenever you do not want to lose your data. The feature also has schema or data-only backups, supports large databases, offers zip compression of the backup files, and other functions to help you safely recover your data.
Scripts folder comparison. Compare database SQL files stored in script folder and see the comparison results in a convenient data grid.
Routine tasks automation. With the help of the Command-Line, you can launch schema comparison and synchronization in a single click. With Windows Scheduler, you can automate the synchronization process. Also, as you use it, you can create and run PowerShell automation scripts.
Supported schema objects. Supported objects for Schema Compare include tables, views, procedures, functions, triggers, events, packages (MariaDB), and sequences (MariaDB).
Database structure comparison setup. Use the Schema Comparison wizard to fine-tune the comparison process, ignore specific events during comparison, and swap the Target and Source databases. With this feature, you can also apply filters for object types and ignore a wide range of object properties.
Comparison results analysis. This functionality gives you a comprehensive view of comparison results in a grid, highlights the differences in text comparator, automatically groups, sorts, filters, and excludes objects by type, and saves the comparison settings.
Comparison results export. Export your comparison results to HTML and XML formats.
CLICK HERE to view the detailed user guide for more information. For more information about the product, please visit the Product Page.