You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

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:


© 2021 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy