What’s New in dbForge Data Generator for MySQL v2.0
Connectivity and Compatibility
- Support for MariaDB 10.1
- Support for MariaDB 10.2
- Support for MariaDB Galera Cluster 5.5 Series
- Support for MariaDB Galera Cluster 10.0 Series
- Support for NDBCLUSTER
- Support for TokuDB
- Support for Galera Cluster
- Support for Google Cloud Platform
- Support for Alibaba Cloud
- Display of MySQL version when testing connection
Data Generator
- Generation of country-specific data
- 10+ new generators added including ICD-10 Codes
- Data generation to existing tables already populated with data
- Improved DateTime generators
- Saving custom generators
- Generating data by a time specified
- Generating data by percent proportion of existing data
- Generating data using a linked table
- Pre and Post Script Execution
SQL Development
- Greatly redesigned SQL Query History
SQL Document
- CTRL+W shortcut for closing current tab
- Opening new tabs next to current one
- CTRL+N shortcut for opening new SQL window with inherited server and database of the current window
- Showing the connection coloring in the status bar
- Each document uses its own connection
- Data Viewer and Editor
- Geometry view for visualizing spatial geometry data
Code Completion
- Percona Server variables (CL, QI and Parameter Info)
- MySQL Server variables
- Variables for MariaDB Server
- Optimizer Hints
- Geographic Functions
- Extended JSON Functions
- Values for TABLE_TYPE
- Multiple-Clustering-Indexes for TokuDB Engine
- Cast(…AS JSON)
- CHANGE MASTER TO
- CHANGE REPLICATION FILTER
- ALTER INSTANCE
- CONNECT Zipped File Tables
- ALTER USER CURRENT_USER
- SHOW CREATE USER
- RESET MASTER
- CREATE [OR REPLACE]…[IF NOT EXISTS]
- Spatial Reference systems
- Compound statements outside of stored programs
- SET DEFAULT ROLE…FOR
- VIR virtual table type for CONNECT engine
- SET ROLE
- CONNECT engine
- SPIDER ENGINE
- START TRANSACTION
- RELEASE_ALL_LOCKS() and ANY_VALUE()
- CREATE TABLE
- Ngram and mecab Full-Text Parser
Other Improvements
- Trial product activation
- Greatly improved visual style of the application with high DPI support
- Compliance with the Federal Information Processing Standard (FIPS)