ApexSQL Power Tools for VS Code release notes

Enhancements:

• Search for objects within MySQL and MariaDB databases
• Quickly find MySQL and MariaDB objects in ApexSQL server explorer
• Save object search results to HTML, CSV, JSON, and XML
• Show MySQL Server users in the ApexSQL server explorer tree view
• Generate Create, Change password, Drop, Grant privileges and Show privileges statements for users
• Show system databases in a separate node of the ApexSQL server explorer tree view
• Query execution on system databases
• The Execute button is added in the query editor

Fixes:

• The "{NULL}" value appears in the empty cells when export results in the HTML format
• The Export to CSV does not work correctly for the values that have a comma (,) punctuation mark
• Connection name in the ApexSQL server explorer pane does not change automatically when the connection in the Connect to server dialog is updated (edited)
• Wrong tooltips for the SSH and SSL tabs in the Connect to server dialog are shown
• "Server already added" message is shown when trying to connect to different MySQL server on the same host with SSH protocol
• Wrong syntax for the Drop index statement is generated when the Show DROP script command is used

Changes:

• The extension now supports Visual Studio Code 1.44.1 and higher versions
• The query results pane now appears at the bottom of the query editor

Features:

• MySQL Server 5.6 and higher support
• MariaDB Server 10.1 and higher support
• Azure Database for MySQL support
• Azure Database for MariaDB support
• Amazon RDS for MySQL support
• Amazon RDS for MariaDB support
• Amazon Aurora MySQL support
• Visual Studio Code 1.38.0 and higher support
• Cross-platform support
• Query execution
• Display query results in Grid format
• Generate Create, Insert, Update, Alter, Drop, Delete statements
• Save results to HTML, Excel, CSV, and JSON
• GUI themes
• High DPI and 4K resolution support
• Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied
• Application telemetry now collects anonymous data on the use and performance of applications and application components