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)