Microsoft Developer presents an episode of Data Exposed, demonstrating the latest features in the MSSQL Extension for Visual Studio Code, including Edit Data, DACPAC import/export, and hands-on demos.

Next-Level SQL in VS Code: Edit Data, DACPAC Import/Export, and New Features

Overview

In this episode of Data Exposed, Microsoft Developer experts explore the latest updates to the MSSQL Extension for Visual Studio Code (v1.40). The session highlights several new features designed to streamline SQL Server and Azure SQL development within Visual Studio Code.

Key Features Demonstrated

• Edit Data:
  • Directly view and modify table data in a grid interface within VS Code without leaving your development environment.
• Database Object Search:
  • Quickly find tables, views, and other objects within your connected databases, enhancing navigation and productivity.
• DACPAC Export/Import:
  • Support for exporting database schemas to DACPAC files and importing them back, enabling easy deployment and database versioning.
• Flat File Import:
  • Import .csv and .txt files directly into your SQL databases from VS Code, simplifying ETL and data onboarding processes.

Demos

This episode includes several live demonstrations showcasing:

• Editing SQL Server and Azure SQL data using the new grid interface
• Running Database Object Search to locate schema objects
• Exporting database schemas as DACPACs and importing them
• Importing flat files into existing tables

Resources

• MSSQL Extension for VS Code
• Demos
• Official Blogs
• Roadmap

Connect

• Yo-Lei Chen (LinkedIn)
• Tauseef Siddique (LinkedIn)
• Anna Hoffman (Twitter)
• Azure SQL Twitter

For more Data Exposed episodes, subscribe here.

About the Presenters

This episode is presented by Microsoft Developer and features product team members who walk through practical scenarios and answer common developer questions about SQL workflows in Visual Studio Code.