ApexSQL Power Tools for VS Code release notes

Fixes:

• 196261: SQL query editor loses focus after entering a single character and typing can't be continued in VS Code version 1.51.1

Changes

• The preview period has been extended to 3/31/2021

Enhancements:

• Browsable code completion list for inserting MySQL and MariaDB keywords, database, schema, object, parameter, and variable names in the SQL statements

Fixes:

• The Paste command under the right-click context menu is missing in a query editor
• The sorting of columns with numeric values in the query results grid are not sorted by the Natural order rule
• The cursor is not shown when a new query editor is opened
• "Error executing query: Unable to connect to any of the specified MySQL hosts" error is encountered when re-executing the same query that was idle for 10 minutes
• "Error executing query: Object reference not set to an instance of an object" error is encountered when executing the code within a file with the .dump extension
• The copied values will be pasted twice in a query editor when the Ctrl+V keyboard shortcut is used
• The custom column order is omitted when data is exported into Excel, CSV, JSON, and HTML from the query results
• "Error generating script: Unknown database" error is encountered when using the Show CREATE script command over a database that has the apostrophe character (') in the name
• "Error generating script: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-' at line 1" error is encountered when using the Show CREATE script command over a database that has the hyphen character (-) in the name
• The Show CREATE script command does not generate the semicolon character (;) at the end of the SQL statement

Fixes:

• "Error generating script: COM Interop is not supported on this platform" error is encountered when any command is clicked in the right-click context menu of ApexSQL server explorer on macOS and Linux operating systems

Enhancements:

• The extension now supports text search within MySQL Server and MariaDB databases
• Navigate to a column in ApexSQL server explorer from found data in the Results grid
• The extension now supports export of text search results to Excel, CSV, JSON, and HTML file formats

Fixes:

• Users are not listed under the Users folder in ApexSQL server explorer for MariaDB 10.4 and higher versions
• DDL and DML scripts are generated incorrectly when user accounts contain special characters

Enhancements:

• Format MySQL and MariaDB scripts using the predefined ApexSQL profile with the Format button in the query editor or with the Format scripts command in the right-click context menu

Fixes:

• Click on the Find button in the Object search window does not start search for objects if the OS regional format date is not English (United States)

Enhancements:

• Search for objects within MySQL and MariaDB databases
• Quickly find MySQL and MariaDB objects in ApexSQL server explorer
• Save object search results to Excel, CSV, JSON, and HTML
• 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 collects anonymous data on the use and performance of application and application components