What’s New in dbForge Studio for MySQL, v6.3

Last modified: September 25, 2024

SQL Editing and Execution

• Command-line interface for SQL formatting
• Query execution pane
• Option to change a snippets folder location
• Phrase completion
• Extended support of MySQL 5.7 in Code Completion
• Option to set files encoding within the /execute command-line operation

Database Explorer

• Alternative ways to create a new object
• Sending objects to a database diagram
• Displaying the objects number

Schema Comparison and Sync

• Selecting object types for comparison

Data Comparison and Sync

• Option to ignore differences in characters that signify the end of line
• Show white spaces option
• Ignore computed columns option
• Setting up the limit size of bulk during synchronization

Data Export and Import

• Export to the Excel 2007 (XLSX) format
• Retaining records filtering when the Export Selected Rows Only option is selected
• Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
• Export to Excel, RTF, PDF with/without a header
• Force quotes option when exporting data to a CSV file
• Option to select encoding when exporting to DBF
• Import of dynamic values from Excel and Excel 2007
• Detecting column types when importing data from the CSV format

Data Report

• Support of report parameters in the command-line interface

Data Editor

• Easy way to hide data results
• Data Viewer and LOB Editor are combined in a single control
• Redirect Data to Output is transformed into additional data editor

Database Restore

• Option to set files encoding within the /restore command-line operation

GUI

• Support of multiple monitors
• Modeless Data Report Wizard windows

Other Features and Improvements

• Enhanced Find and Replace window