{"id":40257,"date":"2022-04-21T09:00:00","date_gmt":"2022-04-21T16:00:00","guid":{"rendered":""},"modified":"2024-04-19T10:36:32","modified_gmt":"2024-04-19T17:36:32","slug":"amplify-your-database-development-experience-with-azure-data-studio","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/","title":{"rendered":"Amplify your database development experience with Azure Data Studio"},"content":{"rendered":"\n<p>It is that time again! We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension, the introduction of advanced features to the Table Designer feature that was initially released in February, some updates to notebooks, Query Plan Viewer, SQL Projects, and Schema Compare.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"announcing-general-availability-for-the-azure-sql-migration-extension-in-azure-data-studio\">Announcing general availability for the Azure SQL migration extension in Azure Data Studio<\/h2>\n\n\n\n<p>We are excited to announce the general availability of the Azure SQL Migration extension for Azure Data Studio. Among many other capabilities, this extension can be used for migrating SQL Server databases to Azure for an enhanced user experience. With this extension, users can get right-sized Azure recommendations based on performance data collected from your source SQL Server databases to optimize for cost and scale. The migration experience is powered by the Azure Database Migration Service which provides a scalable, resilient, and secure way to meet the needs of your organization. See below for a snapshot UI of this extension.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp\" alt=\"Azure SQL Migration UI Snapshot\" class=\"wp-image-40260 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp\"><\/figure>\n\n\n\n<p>With this extension, you can view and monitor the details of your database migrations. This is as simple as migrating your database using the Azure SQL extention and tracking progress and health of these migrations directly on the Azure portal.<\/p>\n\n\n\n<p>To learn more, take a look at our <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-sql-blog\/announcing-azure-sql-migration-extension-for-azure-data-studio\/ba-p\/3284056\" target=\"_blank\" rel=\"noreferrer noopener\">Tech Community blog<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"support-for-net-interactive-notebooks-extension\">Support for .NET Interactive Notebooks extension<\/h2>\n\n\n\n<p>The .NET Interactive Notebooks extension in Azure Data Studio now provides support for additional languages such as C#, F#, and PowerShell. This multi-language experience enables users to use the best language for the task at hand. Even more exciting is that there is now the ability to use multiple languages in the same Interactive notebook and share variables between those languages using SQL Integration.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/NET-img-optimized.webp\" alt=\".NET Interactive Notebooks Extension\" class=\"wp-image-40419 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/NET-img-optimized.webp\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"new-table-designer-features\">New Table Designer features<\/h2>\n\n\n\n<p>Based on user feedback, we have made available more table attributes with advanced features. Azure Data Studio now offers system versioning, graph tables, and Memory-Optimized Tables.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"system-versioned-tables\">System versioned tables<\/h3>\n\n\n\n<p>System versioned tables, also known as Temporal Tables, can now be created in Azure Data Studio, and these tables provide historical information about column data at any given point in time. All data in Temporal Tables exists in direct relation to the time the data was created, updated, or deleted.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"so-why-temporal-tables\">So why Temporal Tables?<\/h4>\n\n\n\n<p>You guessed it, time travel! System versioning makes it easy to perform \u201ctime travel\u201d to see the history of all modifications made to data, which makes tracking changes and data auditing more feasible. Time travel also makes data recovery possible as all changes made to data are tracked in the system-versioned tables, making it easier to revert to the values which existed at the exact time the data was lost. When system versioning is enabled during table creation, the engine automatically creates a separate version of that table. System versioned tables follow the same schema as the original tables from which they were generated.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-1024x423.webp\" alt=\"A system versioned enabled table design\" class=\"wp-image-40263 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-1024x423.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-300x124.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-768x318.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-800x331.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-400x165.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2.webp 1502w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture2-1024x423.webp\"><\/figure>\n\n\n\n<p>In the table above, we have a system version enabled table named \u201cDepartment\u201d. A separate historical table, \u201cdbo.MSS&#8230;\u201d is automatically created to track all changes made to this table. In the original Department table, a series of changes were made. The table below shows all these changes relative to the time frame they existed. For more information, take a look at our <a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/tables\/temporal-tables?view=sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">documentation on system versioned tables<\/a>.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-1024x255.webp\" alt=\"A system versioned enabled table\" class=\"wp-image-40266 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-1024x255.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-300x75.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-768x191.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-800x199.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-400x100.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3.webp 1228w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture3-1024x255.webp\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"graph-tables\">Graph tables<\/h3>\n\n\n\n<p>Graph tables have been available since SQL Server 2017 and can now be designed in Azure Data Studio. Graph tables provide an easier way to create relationships between different datasets using nodes and edge tables. Node or edge tables can be created under any schema in the database, but they all belong to one logical graph. Azure Data Studio brings a newly improved visualization to differentiate node and edge tables. In the table below, node tables are represented by a single dot, while edge tables are depicted by two dots with a line in between connecting them.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Edge.webp\" alt=\"Snapshot Depiction of Node vs Edge Table Types\" class=\"wp-image-40458 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Edge.webp\"><\/figure>\n\n\n\n<p>The image below shows a graph node table in the Table Designer. When a table is indicated as a node, the engine automatically assigns an ID to that table (as seen in the UI as \u201c$node_id\u201d) as this becomes the unique identifier to this table. The script is also updated to indicate that this table is a node table.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-1024x429.webp\" alt=\"Snapshot of a Node Table Design\" class=\"wp-image-40272 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-1024x429.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-300x126.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-768x321.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-800x335.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-400x167.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5.webp 1099w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture5-1024x429.webp\"><\/figure>\n\n\n\n<p>Edge tables, on the other hand, are used to show the relationships between node tables. When an edge table is created, multiple internal columns are created. The ID specific to the edge table, and then the IDs representing the nodes that will be related to each other as seen below. Also, notice the change in the script.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-1024x499.webp\" alt=\"Snapshot of an Edge Table Design\" class=\"wp-image-40275 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-1024x499.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-300x146.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-768x375.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-800x390.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-400x195.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9.webp 1099w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture9-1024x499.webp\"><\/figure>\n\n\n\n<p>The Table Designer fully supports working with edge constraints for SQL graph edge tables. In the image below, our edge table (named \u201cLikes\u201d) is constrained by \u201cPerson to Product\u201d and \u201cPerson to Restaurant\u201d clauses. This means that an edge can either link between \u201cPerson to Product\u201d or \u201cPerson to Restaurant\u201d based on the \u201clikes\u201d. Azure Data Studio brings a one-of-a-kind, easy-to-grasp UI to depict edge and node relationships.<\/p>\n\n\n\n<p>For more information take a look at our <a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/graphs\/sql-graph-architecture?view=sql-server\" target=\"_blank\" rel=\"noreferrer noopener\">documentation on graph tables<\/a>.<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-1024x438.webp\" alt=\"Snapshot of an Edge Table Design showing Constraint configurations\" class=\"wp-image-40278 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-1024x438.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-300x128.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-768x328.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-800x342.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-400x171.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10.webp 1099w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture10-1024x438.webp\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"memory-optimized-tables\">Memory-Optimized Tables<\/h3>\n\n\n\n<p>Memory-Optimized Tables can now be created via Table Designer in Azure Data Studio. With Memory-Optimized Tables, data is persisted in memory, rather than on disk, with the option to include durability to schema and\/or data. This is particularly useful for applications that have databases that undergo multiple concurrent transactions. See image below for memory-optimized configuration and accompanying script changes. For more information take a look at our <a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/in-memory-oltp\/introduction-to-memory-optimized-tables\" target=\"_blank\" rel=\"noreferrer noopener\">memory-optimized tables documentation<\/a>.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture6.webp\" alt=\"Snapshot of a  Memory Optimized Table Design\" class=\"wp-image-40281 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture6.webp\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"query-plan-viewer-updates\">Query Plan Viewer updates<\/h2>\n\n\n\n<p>There have been a small number of visible changes to Query Plan Viewer in this release of Azure Data Studio. We have added icons to note warnings and parallelism when they occur for an operator, and we\u2019ve introduced additional Find options when searching within a plan. There is a new option on the plan toolbar (added to the bottom) which provides the option to disable tooltips, this is particularly helpful when navigating plans with numerous operators.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Tooltip-disabled.webp\" alt=\"Snapshot of plan toolbar showing the tooltip enable\/disable functionality\" class=\"wp-image-40422 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Tooltip-disabled.webp\"><\/figure>\n\n\n\n<p>Finally, we\u2019ve added support for opening saved .sqlplan files in Azure Data Studio, and we addressed some display issues in the Properties window.&nbsp; Expect additional enhancements in the next release.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sql-projects-and-schema-compare\">SQL Projects and Schema Compare<\/h2>\n\n\n\n<p>In the latest release of the SQL Database Projects extension for Azure Data Studio and Microsoft Visual Studio Code, we are introducing a new SQL Projects format based on an SDK-style project file. The SQL project SDK is named, <a href=\"https:\/\/www.nuget.org\/packages\/microsoft.build.sql\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft.Build.Sql<\/a> and it is now available in preview via NuGet and the 0.16.1 version of SQL Database Projects for Azure Data Studio and Visual Studio Code. With Microsoft.Build.Sql, cross-platform pipeline builds are simplified, and the complexity of the project file is significantly reduced. For more information on SDK-style SQL Projects and updates to cross-platform SQL development take a look at <a href=\"https:\/\/aka.ms\/sqlprojsdkblog\" target=\"_blank\" rel=\"noreferrer noopener\">this blog<\/a>.<\/p>\n\n\n\n<p>Other improvements for developers in this release focus on increasing the flexibility of local development. Updating a SQL project from the current state of a database is now enabled in the integration between Schema Compare and SQL Projects and can be accessed directly from the dashboard of a database. For developers focused on working with Azure SQL Database, a new project template has been introduced that enables local validation and testing of SQL Projects for Azure SQL Database.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture8.webp\" alt=\"Snapshot of the dialog for updating a project from a database when launched from a database dashboard\" class=\"wp-image-40287 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture8.webp\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn more<\/h2>\n\n\n\n<p>We are excited to continue this path to modernizing database experiences for developers and database administrators alike. Watch this space for future updates. To learn more about the Azure Data Studio release and journey, check out the <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/release-notes-azure-data-studio?view=sql-server\">release notes for Azure Data Studio<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension.<\/p>\n","protected":false},"author":6051,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2542],"content-type":[2448],"topic":[],"coauthors":[3669],"class_list":["post-40257","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-data-studio","content-type-updates","review-flag-1593580427-503","review-flag-1593580770-633","review-flag-1-1593580431-15","review-flag-and-o-1593580423-560","review-flag-gener-1593580750-651","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-21T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-19T17:36:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png\" \/>\n<meta name=\"author\" content=\"Timi Oshin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Timi Oshin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/timi-oshin\/\",\"@type\":\"Person\",\"@name\":\"Timi Oshin\"}],\"headline\":\"Amplify your database development experience with Azure Data Studio\",\"datePublished\":\"2022-04-21T16:00:00+00:00\",\"dateModified\":\"2024-04-19T17:36:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\"},\"wordCount\":1273,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\",\"name\":\"Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png\",\"datePublished\":\"2022-04-21T16:00:00+00:00\",\"dateModified\":\"2024-04-19T17:36:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp\",\"width\":1000,\"height\":693,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Amplify your database development experience with Azure Data Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/","og_locale":"en_US","og_type":"article","og_title":"Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog","og_description":"We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2022-04-21T16:00:00+00:00","article_modified_time":"2024-04-19T17:36:32+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png","type":"","width":"","height":""}],"author":"Timi Oshin","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Timi Oshin","Est. reading time":"5 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/timi-oshin\/","@type":"Person","@name":"Timi Oshin"}],"headline":"Amplify your database development experience with Azure Data Studio","datePublished":"2022-04-21T16:00:00+00:00","dateModified":"2024-04-19T17:36:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/"},"wordCount":1273,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/","name":"Amplify your database development experience with Azure Data Studio - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.png","datePublished":"2022-04-21T16:00:00+00:00","dateModified":"2024-04-19T17:36:32+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2022\/04\/Picture1.webp","width":1000,"height":693,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/04\/21\/amplify-your-database-development-experience-with-azure-data-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Amplify your database development experience with Azure Data Studio"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/40257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6051"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=40257"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/40257\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=40257"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=40257"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=40257"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=40257"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=40257"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=40257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}