Yes, our entire product line for MySQL is getting an extensive update that packs quite a few useful goodies for your daily work with MySQL and MariaDB databases. Yes, the newly introduced features and enhancements are worth at least a brief look—you’ll find all of them below. And yes, if you are an active user of these tools, you can already update them right on launch. That said, sit back, relax, and let’s get started!
Contents
- Schema Compare for MySQL
- Data Compare for MySQL
- Compare Bundle for MySQL
- Query Builder for MySQL
- Data Generator for MySQL
- Documenter for MySQL
Schema Compare for MySQL
The first tool we’ll talk about Schema Compare for MySQL, an exceptionally helpful assistant when it comes to identifying differences in MySQL/MariaDB database schemas and scripts folders—and synchronizing these differences in a matter of moments. Here’s what awaits you in this update.
- We have added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time.
- We now support spatial reference identifiers (SRID).
- We have also implemented support for Transport Layer Security 1.3, which is the latest version of this cryptographic protocol.
- We have introduced a new group of comparison options called Sequences, which includes Ignore CACHE, Ignore CYCLE, Ignore INCREMENT BY, Ignore MAXVALUE, Ignore MINVALUE, and Ignore START.
- We have improved the behavior of the Ignore Permissions option.
- We have added a new exit code 114 for invalid object filters.
- The object description process now ignores folders with static data, which may contain large files and thus may affect the performance. Now the objects are described faster, and static data is analyzed at the data comparison stage.
- You can now enable/disable the display of DDL differences for pairs of compared objects with the Equal status.
- We’ve introduced support for ASC and DESC in indexes with functional key parts.
- You can now assign columns an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements.
- You can save the .scomp comparison document directly from the comparison wizard.
That’s it! And if you are not using Schema Compare yet, but you’d like to see it in action, that’s no problem. Just download the already updated version from our website for a free 30-day trial. We bet it won’t leave you disappointed.
Data Compare for MySQL
Next comes Data Compare for MySQL, Schema Compare’s twin app that delivers the most convenient way of spotting, inspecting, and synchronizing differences in MySQL table data. Let’s see what we’ve got for you here.
- We have added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time.
- We have extended support for the INET6 data type, intended for the storage of IPv6 addresses.
- We have also introduced support for Transport Layer Security 1.3, which is the latest version of this cryptographic protocol.
- You can now hide empty columns from the grid that displays data differences.
- In case there are NULL → NOT NULL mapped pairs, the synchronization wizard introduces a new page called Issues where you can specify the conflict resolution behavior for potential sync issues.
- You can now save the .dcomp comparison document directly from the comparison wizard.
Now what if you want to get Data Compare for a test drive? You’re free to do it by downloading the updated version for the same 30-day trial. Give it a go in your everyday work and let us know what you think about it.
Compare Bundle for MySQL
How about saving some money on the two aforementioned tools? If you’re interested, we can suggest downloading the latest versions of both Schema and Data Compare in a single Compare Bundle. That’s actually a pretty good investment considering it allows you to save up to 40%—that’s much better than buying these tools separately. And sure, there’s no buying before trying, so your month-long free trial of both tools is firmly in place.
Query Builder for MySQL
Now let’s see what’s been updated in Query Builder for MySQL, which helps create MySQL queries of any complexity on visual diagrams, thus eliminating the need for manual coding.
- We have introduced support for Transport Layer Security 1.3, which is the latest version of this cryptographic protocol.
- We have implemented support for the JSON_TABLE() table function in MariaDB.
- You can now conveniently comment out selections inside a line of code.
- We have added full support for complex VALUE statements.
- The CAST() function now supports the AT TIME ZONE operator.
- Non-aggregated columns are now suggested for GROUP BY statements.
- The Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar have been replaced with a single button Reset Suggestions.
What else is there to say? Feel free to update right now—or, if you are not using Query Builder yet, but it has caught your attention, just get yourself a free 30-day trial and see how easy and convenient it is to build MySQL queries, construct JOINs, and convert statements without writing a single line of code.
Data Generator for MySQL
Data Generator for MySQL is a highly useful tool that can easily generate any volume of compliant, column-intelligent, and realistic dummy data for testing purposes—and populates the required databases with this data in just a few clicks.
- We have added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time.
- We have also extended support for the INET6 data type, intended for the storage of IPv6 addresses.
- We have introduced support for Transport Layer Security 1.3, which is the latest version of this cryptographic protocol.
To see Data Generator in action, simply download it for a free 30-day trial. If you are frequently dealing with the testing of MySQL and MariaDB databases, the boundless versatility and flexibility of this tool will prove invaluable.
Documenter for MySQL
We’ll (almost) conclude this post with Documenter for MySQL, a nice handy application that adeptly provides you with comprehensive database documentation, giving you an accurate picture of your database objects, their properties, and inter-object dependencies. The enhancements are identical to those introduced in Data Generator, but we guess it wouldn’t hurt to list them once more.
- We have added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time.
- We have extended support for the INET6 data type, intended for the storage of IPv6 addresses.
- We have implemented support for Transport Layer Security 1.3, which is the latest version of this cryptographic protocol.
- You can now use ASC | DESC for indexes with functional key parts.
- You can assign columns an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements.
Traditionally, we’d love to invite you to download Documenter for a free 30-day trial and check it in action today!
Explore the newly enhanced capabilities of dbForge tools for MySQL!
Like we said before, if you are an active user of dbForge tools for MySQL, the update will await you on the next launch—alternatively, you can go to the Help menu > Check for Updates. And if you are a newcomer, we gladly invite you to download any of our tools for a free 30-day trial and see how they can help you in your daily work with MySQL and MariaDB. And of course, we’d love to hear your feedback, so don’t hesitate to contact us at any moment.
