DB Best has released a new version of Database Compare Suite. This version supports MariaDB, a popular fork of MySQL database platform. Another major improvement of the latest release is virtual views.
The list of updates includes:
Read this blog post to discover how to use these data objects and when you need to create them.
Database Compare Suite supports MariaDB
Database Compare Suite now allows you to work with MariaDB databases. The application uses the built-in Microsoft Windows drivers to connect to MariaDB databases. So, all you need to do to start working with MariaDB is to install the Database Compare Suite application.
You can compare data between MariaDB and any other supported database platform. Currently, Database Compare Suite supports 18 database platforms. Be sure to check the official Database Compare Suite product page to see the full list of supported databases.
Benefits of using virtual views
Using Database Compare Suite in multiple database migration projects, we often face a limitation with database access rights. For example, you may not have a user with access rights to create views in the database. In this case, the only way to select data for comparison from a system table is to run a query. Then you will need to compare the query output with the reference data manually.
By introducing virtual views in Database Compare Suite, you now have a new virtual data type that allows for storing the result of query execution. You can include virtual views in data operations alongside regular objects (tables and views) as well as other virtual views.
When creating a virtual view, you need to specify the SQL statement that allows for selecting data from your database objects. You can load the script from a file or write it directly in the query editor window.
Before saving the virtual view, you need to make sure that the SQL script can be executed. To do so, press the Execute script in SQL console.
You can edit existing virtual views or remove them from the project. Watch the following video to see how to create and use virtual views in Database Compare Suite.
Limitations of virtual views
Please note that virtual views can interact with all database schemas and objects if you use fully qualified object names. At the same time, virtual views are available only within the scope of the Database Compare Suite project. In other words, they are not physical database objects, and you will not see them if you access your database via another database management application.
You can’t apply matching rules for virtual views. Finally, you can only use the order of columns in the virtual view defined by your query. If you need to change this order, you need to edit the query.
User interface updates
Based on our customer’s feedback, we made a small but important user interface update. A new Restart button in Database Compare Suite 5.2 gives you the ability to quickly relaunch a comparison or migration operation for the same pair of objects. With that said, Database Compare Suite refreshes data from the database.
Working with the same pair of objects for a long time, you don’t need to specify all the operation settings every time you need to compare them. All you need to do is press the Restart button in the tab with the previous operation results. Database Compare Suite will reconnect to the databases to refresh data and then launch the specified operation using the previously defined settings and scope of objects.
Also, we added the ability to use tolerance when comparing data and time values in Database Compare Suite. You can treat two date and time values as equal, ignoring the specified difference from a range of values from 1 second to 23 hours 59 minutes 59 seconds.
Database Compare Suite supports 18 database platforms and proves to be a helpful tool for all database administrators who manage multiple database instances. You can download a free 14-day trial version of the application from the Database Compare Suite page.
Also, be sure to read the series of blog posts that cover the core application features: