Softpedia >Windows >Internet >Servers >Database Utils >ApexSQL Database Power Tools for VS Code >  Changelog

ApexSQL Database Power Tools for VS Code Changelog

What's new in ApexSQL Database Power Tools for VS Code 2021.1.81

Jan 15, 2023
  • Enhancements:
  • Format MySQL and MariaDB scripts using predefined profiles: Compact and Extended
  • Fixes:
  • 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

New in ApexSQL Database Power Tools for VS Code 2020.7.51 (Dec 7, 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

New in ApexSQL Database Power Tools for VS Code 2020.6.50 (Nov 17, 2020)

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

New in ApexSQL Database Power Tools for VS Code 2020.6.48 (Sep 18, 2020)

  • 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

New in ApexSQL Database Power Tools for VS Code 2020.5.30 (Aug 17, 2020)

  • Enhancements:
  • The extension now supports text search within MySQL Sever 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

New in ApexSQL Database Power Tools for VS Code 2020.4.20 (Aug 12, 2020)

  • 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

New in ApexSQL Database Power Tools for VS Code 2020.3.19 (Jul 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)

New in ApexSQL Database Power Tools for VS Code 2020.2.18 (Jul 8, 2020)

  • Enhancements:
  • Search for objects within MySQL and MariaDB databases
  • Quickly find MySQL and MariaDB objects in ApexSQL server explorer
  • Save 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