For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Database Power Tools for VS Code release notes

Release:

2021.1.81

Date:

March 22, 2021

Enhancements:

Fixes:

  • 202879: Values are not shown correctly in the Results grid for a column that is created using the Serial alias on MariaDB databases

Changes:

  • The application is now part of the ApexSQL Fundamentals Toolkit for MySQL bundle and requires activation

Known issues:

  • Users cannot successfully log in to the Quest account when using a proxy server with the username and password

Release:

2020.7.51

Date:

December 07, 2020

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

Release:

2020.6.48

Date:

September 18, 2020

Enhancements:

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

Release:

2020.5.35

Date:

August 25, 2020

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

Release:

2020.5.30

Date:

August 17, 2020

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

Release:

2020.4.20

Date:

August 12, 2020

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

Release:

2020.3.19

Date:

July 27, 2020

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)

Release:

2020.2.18

Date:

July 07, 2020

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

Release:

2020.1.17

Date:

May 7, 2020

Features: