{"id":6364,"date":"2026-02-25T09:00:27","date_gmt":"2026-02-25T17:00:27","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=6364"},"modified":"2026-02-25T19:26:26","modified_gmt":"2026-02-26T03:26:26","slug":"vscode-mssql-feb-2026","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/vscode-mssql-feb-2026\/","title":{"rendered":"MSSQL Extension for VS Code: Query Profiler, ADS Migration Toolkit &amp; More"},"content":{"rendered":"<p>The <a href=\"http:\/\/aka.ms\/vscode-mssql\" target=\"_blank\" rel=\"noopener\">MSSQL Extension for VS Code<\/a> continues to evolve, delivering features that make SQL development more integrated, more powerful, and more developer-friendly. In version v1.40.0, we&#8217;re introducing the <strong>ADS Migration Toolkit, Basic Database Management, Flat File Import, Database Backup &amp; Restore, Database Object Search, and Query Profiler<\/strong> \u2014 six capabilities that bring seamless Azure Data Studio migration, essential database operations, and real-time performance monitoring directly into your development workflow inside Visual Studio Code.<\/p>\n<h2 id=\"what\u2019s-new-in-mssql-extension-for-vs-code-v1.36\"><b>What\u2019s new in MSSQL extension for VS Code v1.40<\/b><\/h2>\n<p><iframe title=\"What&#039;s New in MSSQL Extension for VS Code v1.40 | Query Profiler, ADS Migration toolkit &amp; More\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/P1dYAz6IJ9o?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p class=\"p1\">This release introduces six major capabilities designed to streamline the SQL development experience:<\/p>\n<ul>\n<li><strong>ADS Migration Toolkit<\/strong> \u2014 Migrate your saved connections, connection groups, settings, and key bindings from Azure Data Studio to VS Code in a single guided flow. Includes the MSSQL Database Management Keymap companion extension for ADS-aligned shortcuts like F5 to run queries, Ctrl+L for estimated plans, and more.<\/li>\n<li><strong>Database Object Search<\/strong> \u2014 Find tables, views, stored procedures, and functions across your databases instantly. Search by name or use type prefixes (t:, v:, sp:, f:), filter by schema, switch databases from a dropdown, and script objects directly from the results panel.<\/li>\n<li><strong>Basic Database Management (Public Preview)<\/strong> \u2014 Create, rename, and drop databases directly from the Object Explorer, with support for advanced options like collation, recovery model, and compatibility level. Generate T-SQL scripts for any operation.<\/li>\n<li><strong>Flat File Import (Public Preview)<\/strong> \u2014 Import CSV and TXT files into a new SQL Server table with a step-by-step guided wizard. Automatically infer column names and data types, customize the schema before import, and set primary keys and nullability \u2014 all without leaving VS Code.<\/li>\n<li><strong>Database Backup &amp; Restore (Public Preview)<\/strong> \u2014 Back up databases to disk or Azure Blob Storage with support for full, differential, and transaction log backup types. Restore from existing backup sets, .bak files, or Azure Blob Storage URLs, with options to drop active connections and manage backup history.<\/li>\n<li><strong>Query Profiler (Public Preview)<\/strong> \u2014 Capture and monitor real-time database activity powered by Extended Events, directly inside VS Code. Select from profiling templates, apply column filters, manage multiple concurrent sessions, export captured events to CSV, and open existing .xel files \u2014 all without switching tools. Supported for SQL Server (on-premises and cloud) and Azure SQL Database.<\/li>\n<\/ul>\n<h2><b>ADS Migration Toolkit\u00a0<\/b><\/h2>\n<div>First, <strong>Azure Data Studio Migration Toolkit<\/strong>\u00a0helps users smoothly transition from Azure Data Studio to the MSSQL extension for Visual Studio Code by importing their existing environment. It preserves key elements such as database connections, connection groups, supported settings, and familiar SQL keybindings, allowing users to continue working productively in VS Code with minimal disruption<\/div>\n<h3><span data-contrast=\"none\">Key highlights<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:360,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h3>\n<ul>\n<li>Imports existing database connections and connection groups from Azure Data Studio into the MSSQL Object Explorer, maintaining organization and metadata like server, database, and authentication details.<\/li>\n<li>Migrates supported editor and SQL-related settings to align behavior between Azure Data Studio and VS Code.<\/li>\n<li>Preserves familiar workflows by enabling ADS-style SQL keybindings via the MSSQL Database Management Keymap extension.<\/li>\n<li>Provides a guided migration flow through the MSSQL extension, allowing users to selectively import connections, groups, settings, and keybindings.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog.webp\"><img decoding=\"async\" class=\"alignnone wp-image-6666 \" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog.webp\" alt=\"migration dialog image\" width=\"1067\" height=\"624\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog.webp 1647w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog-300x175.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog-1024x599.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog-768x449.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/migration_dialog-1536x898.webp 1536w\" sizes=\"(max-width: 1067px) 100vw, 1067px\" \/><\/a><\/p>\n<h2><b>Database Object Search<\/b><\/h2>\n<p>Additionally, the <strong>Database Object Search<\/strong> in the MSSQL extension for Visual Studio Code lets you quickly find tables, views, functions, and stored procedures.<\/p>\n<p>To open Database Object Search, right-click on the server or database node in the object explorer and select <strong>Search Database Objects<\/strong> from the menu. This opens a searchable list of objects in the selected database.<\/p>\n<p>In the search view, type an object name (partial matches work) or use type prefixes\u2014<strong data-start=\"377\" data-end=\"383\">t:<\/strong> (table), <strong data-start=\"393\" data-end=\"399\">v:<\/strong> (view), <strong data-start=\"408\" data-end=\"414\">f:<\/strong> (function), <strong data-start=\"427\" data-end=\"434\">sp:<\/strong> (stored procedure)\u2014for example, <code data-start=\"467\" data-end=\"482\">t:&lt;TableName&gt;<\/code> or <code data-start=\"486\" data-end=\"512\">sp:&lt;StoredProcedureName&gt;<\/code>. You can also switch databases from the left dropdown, filter by type or schema, and refresh results.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view.webp\"><img decoding=\"async\" class=\"alignnone wp-image-6591\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view.webp\" alt=\"database object search view image\" width=\"1044\" height=\"539\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view.webp 2107w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view-300x155.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view-1024x529.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view-768x397.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view-1536x793.webp 1536w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-view-2048x1058.webp 2048w\" sizes=\"(max-width: 1044px) 100vw, 1044px\" \/><\/a><\/p>\n<p>Each result row includes an <strong>Actions<\/strong> menu (\u2026) with common operations like full scripting options, Edit Data, Modify Data, Copy Object Name, etc.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions.webp\"><img decoding=\"async\" class=\"alignnone wp-image-6590\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions.webp\" alt=\"database object search actions image\" width=\"669\" height=\"344\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions.webp 1201w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions-300x154.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions-1024x526.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/database-object-search-actions-768x395.webp 768w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<h2><b>Basic Database Management (Preview)<\/b><\/h2>\n<p>Next,<strong> Database Management Tools (Preview)<\/strong> in the MSSQL extension let you perform common database administration tasks directly from the editor UI, reducing context switching and simplifying day\u2011to\u2011day database management. The preview focuses on essential operations\u2014creating, renaming, and dropping databases\u2014through guided dialogs that surface relevant information and safeguards.<\/p>\n<h3><span data-contrast=\"none\">Key highlights<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:360,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h3>\n<ul>\n<li>Create new databases quickly from a dialog where you specify the database name and owner, with the database appearing immediately in the server\u2019s Databases list.<\/li>\n<li>Rename existing databases in place without leaving the editor, with simple confirm and cancel controls and automatic refresh in the object tree.<\/li>\n<li>Drop databases through a dedicated dialog that clearly shows database details.<\/li>\n<\/ul>\n<h2><b>Flat File Import (Preview)<\/b><\/h2>\n<p>Furthermore, the <strong>Import Flat File (Preview)<\/strong> feature in the MSSQL extension lets you quickly create a new SQL Server table and load data from structured text files through a guided, end\u2011to\u2011end workflow. The experience analyzes the file, previews inferred schema and data, allows schema adjustments, and completes table creation and data import in a single flow, reducing manual setup and scripting.<\/p>\n<h3><span data-contrast=\"none\">Key highlights<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:360,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h3>\n<ul>\n<li>Guided wizard that analyzes flat files and previews inferred schema and sample data before import.<\/li>\n<li>Supports common text\u2011based formats including .csv and .txt files with tabular data only.<\/li>\n<li>Allows schema customization, including column names, data types, primary keys, and nullability.<\/li>\n<li>Creates a new table and imports data in one continuous workflow from the MSSQL extension UI<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-6670\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog.webp\" alt=\"flat file dialog image\" width=\"516\" height=\"532\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog.webp 516w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog-291x300.webp 291w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog-24x24.webp 24w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/flat_file_dialog-48x48.webp 48w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<h2><b>Database Backup and Restore (Preview)<\/b><\/h2>\n<p>In addition,<strong> Database Backup and Restore (Preview)<\/strong> in the MSSQL extension for Visual Studio Code provides a guided, UI\u2011based experience for performing SQL Server backup and restore operations directly from Object Explorer. These preview features reduce the need for manual scripting while still allowing users to generate equivalent T\u2011SQL when needed, and support both local and Azure\u2011based workflows<\/p>\n<h3><span data-contrast=\"none\">Key highlights<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:360,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h3>\n<ul>\n<li>Launch Backup Database and Restore Database directly from the database context menu in Object Explorer.<\/li>\n<li>Create full, differential, or transaction log backups, with optional copy\u2011only support that does not affect the backup chain.<\/li>\n<li>Save backups either to disk or to Azure Blob Storage using a guided Azure account and storage selection flow.<\/li>\n<li>Restore databases from existing backup history, local .bak files, or Azure Blob Storage URLs, with visibility into available backup sets and metadata.<\/li>\n<li>Generate the equivalent T\u2011SQL script for backup and restore actions directly from the dialogs.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog.webp\"><img decoding=\"async\" class=\"alignnone size-large wp-image-6671\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog-1024x833.webp\" alt=\"restore dialog image\" width=\"1024\" height=\"833\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog-1024x833.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog-300x244.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog-768x625.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/restore_dialog.webp 1063w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h2><b>Query Profiler<\/b><\/h2>\n<p>Finally, the MSSQL extension now includes <strong>Query Profiler<\/strong>, a real-time database activity monitor powered by Extended Events, directly inside VS Code. Query Profiler replaces the need to switch to external profiling tools by letting you capture, filter, and analyze live T-SQL activity without leaving your editor.<\/p>\n<p>To try it, right-click any server in <strong>Object Explorer<\/strong> and select <strong>Launch Query Profiler (Preview)<\/strong>, or run <strong>MSSQL: Launch Query Profiler<\/strong> from the Command Palette.<\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Real-time event streaming<\/strong> \u2013 Capture live query activity in a scrollable events grid with columns like EventClass, TextData, Duration, and DatabaseName.<\/li>\n<li><strong>Built-in templates<\/strong> \u2013 Choose from five profiling templates (<code>Standard_OnPrem<\/code>, <code>TSQL_OnPrem<\/code>, <code>TSQL_Locks<\/code>, <code>TSQL_Duration<\/code>, <code>Standard_Azure<\/code>) with automatic selection for Azure SQL Database targets.<\/li>\n<li><strong>Column filters<\/strong> \u2013 Filter events by text values, numeric thresholds, or search across all columns with the quick filter.<\/li>\n<li><strong>Multiple concurrent sessions<\/strong> \u2013 Run several profiling sessions at once, each with its own connection and template, and switch between them with the session selector.<\/li>\n<li><strong>Export to CSV<\/strong> \u2013 Save captured events for offline review or sharing.<\/li>\n<li><strong>Open XEL files<\/strong> \u2013 Load existing Extended Events trace files (<code>.xel<\/code>) into the Profiler grid for review with full filtering capabilities.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu.webp\"><img decoding=\"async\" class=\"alignnone wp-image-6594\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu.webp\" alt=\"query profiler context menu image\" width=\"1075\" height=\"638\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu.webp 1665w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu-300x178.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu-1024x608.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu-768x456.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-context-menu-1536x911.webp 1536w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters.webp\"><img decoding=\"async\" class=\"alignnone wp-image-6595\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters.webp\" alt=\"query profiler filters image\" width=\"1051\" height=\"624\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters.webp 1669w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters-300x178.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters-1024x607.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters-768x456.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/02\/query-profiler-filters-1536x911.webp 1536w\" sizes=\"(max-width: 1051px) 100vw, 1051px\" \/><\/a><\/p>\n<p>Query Profiler helps developers identify slow queries, spot performance bottlenecks, and understand how their application interacts with the database during development and testing. It works with SQL Server (on-premises, VMs, containers) and Azure SQL Database.<\/p>\n<p>Learn more:<\/p>\n<ul>\n<li><a href=\"https:\/\/aka.ms\/vscode-mssql-query-profiler-docs\" target=\"_blank\" rel=\"noopener\">Documentation<\/a><\/li>\n<li><a href=\"https:\/\/aka.ms\/vscode-mssql-query-profiler-demo\" target=\"_blank\" rel=\"noopener\">Demo<\/a><\/li>\n<\/ul>\n<h2><b>SQL Database Projects Publish Dialog (GA)<\/b><\/h2>\n<p><span data-contrast=\"auto\">We&#8217;ve\u00a0made some updates to SQL Database Projects in VS Code that streamline database development workflows.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:true,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The\u00a0<\/span><b><span data-contrast=\"auto\">Publish Dialog<\/span><\/b><span data-contrast=\"auto\">\u00a0is now generally available. You can configure connections, review deployment options, and publish schema changes directly from the editor without writing\u00a0SqlPackage\u00a0commands manually. For teams using CI\/CD, the dialog generates the equivalent command that you can drop into your pipeline scripts.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:true,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">We&#8217;ve\u00a0also\u00a0<\/span><b><span data-contrast=\"auto\">expanded item templates<\/span><\/b><span data-contrast=\"auto\">\u00a0to cover more database object types. When you add a stored procedure, view, table, or other schema object to your project,\u00a0you&#8217;ll\u00a0start with structured code instead of an empty file, making it faster to\u00a0build out\u00a0your database schema.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:true,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Both features are available in the latest version of the SQL Database Projects extension for VS Code.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:true,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<h2><b>Other updates<\/b><\/h2>\n<ul>\n<li class=\"whitespace-normal break-words pl-2\"><strong>SQL 2025 SQL Containers on ARM<\/strong> \u2014 Added support back for SQL Server 2025 containers on ARM-based macOS devices.<\/li>\n<li><strong>SQL Database Projects bug fixes<\/strong> \u2014 Fixed several issues related to database references and building projects in VS Code.<\/li>\n<li class=\"whitespace-normal break-words pl-2\"><strong>Quality improvements<\/strong> \u2014 Enhanced performance and usability of the query results grid, fixed accessibility issues affecting error messages and UI feedback, and addressed edge case errors in GitHub Copilot Agent Mode when switching connections.<\/li>\n<\/ul>\n<h2>Conclusion<\/h2>\n<p class=\"p1\">The v1.40 release introduces the <strong>ADS Migration Toolkit, Basic Database Management, Flat File Import, Database Backup &amp; Restore, Database Object Search, and Query Profiler<\/strong> \u2014 six major updates that streamline Azure Data Studio migration, essential database operations, and real-time performance monitoring. Together, these capabilities make the MSSQL extension more powerful, more integrated, and more developer-friendly than ever.<\/p>\n<p>If there\u2019s something you\u2019d love to see in a future update, here\u2019s how you can contribute:<\/p>\n<ul>\n<li>\ud83d\udcac <a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\" target=\"_blank\" rel=\"noopener\">GitHub discussions<\/a> \u2013 Share your ideas and suggestions to improve the extension<\/li>\n<li>\u2728 <a href=\"https:\/\/aka.ms\/vscode-mssql-feature-request\" target=\"_blank\" rel=\"noopener\">New feature requests<\/a> \u2013 Request missing capabilities and help shape future updates<\/li>\n<li>\ud83d\udc1e <a href=\"https:\/\/aka.ms\/vscode-mssql-bug\" target=\"_blank\" rel=\"noopener\">Report bugs<\/a> \u2013 Help us track down and fix issues to make the extension more reliable<\/li>\n<\/ul>\n<p class=\"p1\">Want to see these features in action?<\/p>\n<ul>\n<li class=\"p1\"><a href=\"https:\/\/youtu.be\/P1dYAz6IJ9o\" target=\"_blank\" rel=\"noopener\">MSSQL 1.40 release demos<\/a><\/li>\n<li><a href=\"https:\/\/aka.ms\/vscode-mssql-demos\" target=\"_blank\" rel=\"noopener\">Full playlist of demos<\/a><\/li>\n<\/ul>\n<p>Thanks for being part of the journey\u2014happy coding! \ud83d\ude80<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more integrated, more powerful, and more developer-friendly. In version v1.40.0, we&#8217;re introducing the ADS Migration Toolkit, Basic Database Management, Flat File Import, Database Backup &amp; Restore, Database Object Search, and Query Profiler \u2014 six capabilities that bring seamless Azure Data [&hellip;]<\/p>\n","protected":false},"author":132338,"featured_media":6675,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,625],"tags":[708,717,709,716,715,718,714,682],"class_list":["post-6364","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-vs-code","tag-ads","tag-ads-migration","tag-ads-retirement","tag-backup-and-restore","tag-database-object-search","tag-flat-file-import","tag-query-profiler","tag-vscode-mssql"],"acf":[],"blog_post_summary":"<p>The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more integrated, more powerful, and more developer-friendly. In version v1.40.0, we&#8217;re introducing the ADS Migration Toolkit, Basic Database Management, Flat File Import, Database Backup &amp; Restore, Database Object Search, and Query Profiler \u2014 six capabilities that bring seamless Azure Data [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/132338"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=6364"}],"version-history":[{"count":3,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6364\/revisions"}],"predecessor-version":[{"id":6690,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6364\/revisions\/6690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/6675"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=6364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=6364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=6364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}