Level Up Database Development with the Newly Enhanced dbForge Tools for MySQL v10.0
Published: 2023-11-08 13:51:39

_dbForge tools for MySQL have just received an extensive update, which includes a number of extremely practical features, designed to make the most of MySQL and MariaDB database management_

Devart, one of the leading developers of database management software, ALM solutions, and data providers for the most popular database servers, has significantly updated dbForge tools for MySQL (version 10.0). These major enhancements allow software and database  developers to bring their daily performance to the new heights of efficiency.

Let’s take a look at how the functionality of dbForge tools for MySQL has been enhanced product by product.

**Schema Compare for MySQL** is an extraordinarily helpful assistant for spotting differences between **MySQL/MariaDB** database schemas and scripts folders. It has received the following enhancements:

- Support for **temporal tables in MariaDB**, which allow maintaining historical versions of data and tracking changes in data over time
- Support for **Spatial reference identifiers (SRID)**
- Support for **Transport Layer Security 1.3**
- Introduction of **Sequences**, a new group of comparison options that includes **Ignore CACHE**, **Ignore CYCLE**, **Ignore INCREMENT BY**, **Ignore MAXVALUE**, **Ignore MINVALUE**, and **Ignore START**
- **Faster object description** process
- **ASC | DESC** is now available for indexes with functional key parts
- The **INVISIBLE** attribute can now be assigned to columns in CREATE TABLE and ALTER TABLE statements
- A new option that enables and disables **the display of DDL differences** for pairs of compared objects with the **Equal** status

**Data Compare for MySQL**, an application that delivers the most convenient way of spotting, inspecting, and synchronizing differences in MySQL table data, has received the following updates:

- Support for **temporal tables in MariaDB**
- Extended support for the **INET6 data type**, intended for the storage of IPv6 addresses
- Support for **Transport Layer Security 1.3**
- A new option to **hide empty columns** from the grid that displays data differences
- A new synchronization wizard page called **Issues** where users can specify the conflict resolution behavior for potential sync issues

**Query Builder for MySQL**, a tool that helps create MySQL queries on visual diagrams, has the following enhancements:

- Support for **Transport Layer Security 1.3**
- Support for the **JSON_TABLE()** table function in MariaDB
- Ability to **comment out selections inside a line of code**
- Full support for complex **VALUE** statements
- Newly added support for the **AT TIME ZONE** operator within the **CAST()** function
- Suggestions of **non-aggregated columns** for **GROUP BY** statements

**Data Generator for MySQL**, a tool that can generate any volume of compliant, column-intelligent, and realistic dummy data for testing purposes, has also received a few enhancements:

- Support for **temporal tables in MariaDB**
- Extended support for the **INET6 data type**, intended for the storage of IPv6 addresses
- Support for **Transport Layer Security 1.3**

**Documenter for MySQL**, an application that proficiently supplies users with extensive database documentation, has the same additions as those found in Data Generator, plus the following extra features:

- **ASC | DESC** is now available for indexes with functional key parts
- The **INVISIBLE** attribute can now be assigned to columns in CREATE TABLE and ALTER TABLE statements

The latest versions of all these tools are available for a free 30-day trial. Schema and Data Compare are can be purchased in a single **Compare Bundle**, which allows **saving up to 40%**.

You can find the full list of new features and enhancements here: https://blog.devart.com/make-sure-you-dont-miss-the-latest-update-of-dbforge-tools-for-mysql.html

**About Devart**

Devart is a multi-product company, one of the leading developers of database management software, ALM solutions, data providers for database servers, as well as data integration and backup solutions.
For additional information about Devart, please visit https://www.devart.com