Edit

Share via

Data-tier Application (Preview)

The Data-tier Application experience provides an easy-to-use experience to deploy and extract .dacpac files and import and export .bacpac files.

Note

Fabric targets aren't currently supported in this preview.

This experience makes it easier to manage .dacpac and .bacpac files. It simplifies the development and deployment of data-tier elements that support your application. For more information, see Data-tier applications (DAC) overview.

Features

  • Deploy a .dacpac file to a new or existing SQL database (Publish DACPAC)
  • Extract the schema from a SQL database to a .dacpac file (Extract DACPAC)
  • Import a .bacpac file to a new or empty database (Import BACPAC)
  • Export the schema and data from a SQL database to a .bacpac file (Export BACPAC)

Install the MSSQL extension

To use the Data-tier Application features, install the MSSQL extension for Visual Studio Code.

  1. In Visual Studio Code, select the Extensions icon to view available extensions.

    Screenshot of installing the MSSQL extension in Visual Studio Code.

  2. Search for the SQL Server (mssql) extension and select it to view its details. Select Install to add the extension.

  3. Once installed, Reload to enable the extension in Visual Studio Code (only required when installing an extension for the first time).

Tip

For a comprehensive overview of the MSSQL extension's features and capabilities, see the MSSQL extension for Visual Studio Code.

Launch the Data-tier Application experience

To launch the experience in the MSSQL extension for Visual Studio Code, right-click the Databases node, or right-click a specific database in the Object Explorer. Then, select Data-tier Application.

Screenshot of launching the Data-tier Application experience in the MSSQL extension for Visual Studio Code.

Related content

  • Last updated on