Database operations

The MSSQL extension for Visual Studio Code provides built-in tools for common database operations. You can create and manage databases, search for objects, back up and restore databases, and import

The MSSQL extension for Visual Studio Code provides built-in tools for common database

operations. You can create and manage databases, search for objects, back up and restore

databases, and import data from flat files, all without leaving the editor.

Description

Database

management

Create, rename, and drop databases directly from the Object Explorer.

Database Object

Find tables, views, functions, and stored procedures with type-aware search.

Backup database

Back up databases to disk or Azure Blob Storage with full, differential, or

transaction log options.

Restore database

Restore databases from existing backup sets, backup files, or Azure Blob Storage.

Import flat file

Import CSV and TXT files into new SQL Server tables with a guided wizard.

The MSSQL extension provides dialogs for creating, renaming, and dropping databases directly

from the.

In the

view, right-click a SQL Server instance node.

Select.
In the

dialog, enter the following information:

ﾉ

Expand table



Tip

The features on this page are currently in preview and might change based on feedback.

Join the community at

to share ideas or report issues.