What’s new in ApexSQL: ApexSQL Database Power Tools for VS Code

We are proud to announce the first extension for Visual Studio Code from the ApexSQL family: ApexSQL Database Power Tools for VS Code. This extension provides a connection to the MySQL and MariaDB instances, explores database objects, generates DDL (Create, Alter, Drop) and DML (Select, Insert, Update, Delete) scripts for a variety of objects (tables, view, stored procedures, functions).

Installation

Installation of ApexSQL Database Power Tools for VS Code is very straightforward. Under the Extensions pane, click the ellipse (…) button and from the context menu, choose the Install from VSIX command:

Install ApexSQL Database Power Tools for VS Code

Choose the .vsix file and click the Install button:

VSIX installation window

Another way to install the ApexSQL Database Power Tools for VS Code extension is via Visual Studio Code Marketplace. In the search box type “ApexSQL Database Power Tools for VS Code” and click the Install button:

Install ApexSQL Database Power Tools for VS Code from Visual Studio Code Marketplace

Connections

With ApexSQL Database Power Tools for VS Code, a connection to MySQL Server 5.6/MariaDB 10.1 and higher versions can be established using one of three available type connections (TCP/IP, Local Socket/Pipe, TCP/IP over SSH):

ApexSQL Database Power Tools for VS Code connection dialog

ApexSQL Database Power Tools for VS Code supports connection to the cloud MySQL and MariaDB databases (Azure Databases for MySQL, Amazon RDS for MySQL) as well.

All MySQL and MariaDB established connection will be shown in the ApexSQL object explorer pane. ApexSQL object explorer provides a hierarchical user interface to view and manage the objects in each instance of MySQL and MariaDB:

ApexSQL Database Power Tools for VS Code object explorer

ApexSQL Database Power Tools for VS Code can be used on different platforms such as Windows, Linux, macOS:

ApexSQL Database Power Tools for VS Code on Ubuntu

Under the ApexSQL object explorer, user can choose several types to script an object, right-click on an object (table, view, etc.) and from the context menu, choose one of the available DDL (Create, Alter, Drop) and DML (Select, Insert, Update, Delete) commands:

Create DDL and DML scripts

All query results can be exported in one of the available formats (CSV, HTML, Excel, JSON):

Export results in CSV, HTML, Excel, JSON file formats

This will be the initial version of the extension, but the future versions will include more features as we plan to build a powerful tool with a bunch of useful options that will help you achieve maximum productivity with minimal effort.

 

April 7, 2020