{"id":7980,"date":"2026-11-17T17:02:47","date_gmt":"2026-11-18T01:02:47","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=7980"},"modified":"2026-11-17T17:02:47","modified_gmt":"2026-11-18T01:02:47","slug":"new-create-and-apply-wizards-in-ssms-preview","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/new-create-and-apply-wizards-in-ssms-preview\/","title":{"rendered":"New Create and Apply wizards in SSMS (Preview)"},"content":{"rendered":"<p>Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing options confusing? SQL Server Management Studio (SSMS) has new preview wizards that streamlines those tasks: <strong>Create bacpac\/dacpac<\/strong> and <strong>Apply bacpac\/dacpac<\/strong>.<\/p>\n<p>The Create wizard guides you through the process of generating a bacpac or dacpac with straightforward steps based on your goal.\u00a0 The Apply wizard uses the package format to show the options for a schema deployment or a schema-and-data import. You can also create a new database and go straight into Apply.<\/p>\n<blockquote><p><strong>Preview:<\/strong> The <strong>Create<\/strong> and <strong>Apply<\/strong> wizards and the <strong>Create database from bacpac\/dacpac<\/strong> command are in preview.<\/p><\/blockquote>\n<h2>Designed for the task outcome<\/h2>\n<p>The new wizards consolidate the previous collection of commands into outcome-oriented tasks.\u00a0 Instead of remembering if an extract or an export is needed, the wizard simply guides you based on your intent of generating a file that has the schema only or the schema and data.\u00a0 When you are ready to use the file, the Apply wizard guides you step by step in reaching your intent on the target database.<\/p>\n<figure class=\"wp-block-table\">\n<table style=\"width: 100%;\">\n<caption>Create and Apply at a glance<\/caption>\n<thead>\n<tr>\n<th style=\"width: 16.9919%;\" scope=\"col\">Task<\/th>\n<th style=\"width: 44.7154%;\" scope=\"col\">DACPAC<\/th>\n<th style=\"width: 37.561%;\" scope=\"col\">BACPAC<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<th style=\"width: 16.9919%;\" scope=\"row\">Create a package file<\/th>\n<td style=\"width: 44.7154%;\">Save the database schema without table data.<\/td>\n<td style=\"width: 37.561%;\">Save the schema and data from the tables you select.<\/td>\n<\/tr>\n<tr>\n<th style=\"width: 16.9919%;\" scope=\"row\">Apply a package file<\/th>\n<td style=\"width: 44.7154%;\">Calculate schema differences and apply changes according to the selected publish options.<\/td>\n<td style=\"width: 37.561%;\">Import schema and data into a database with no user-defined objects.<\/td>\n<\/tr>\n<tr>\n<th style=\"width: 16.9919%;\" scope=\"row\">Target database<\/th>\n<td style=\"width: 44.7154%;\">Empty or populated.<\/td>\n<td style=\"width: 37.561%;\">Empty. Import doesn&#8217;t merge data into existing tables.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>For more about the formats, see the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/tools\/sql-database-projects\/concepts\/data-tier-applications\/overview\">DACPAC and BACPAC overview<\/a>.<\/p>\n<h2>Create a DACPAC or BACPAC<\/h2>\n<p>In <strong>Object Explorer<\/strong>, right-click the source database and select <strong>Tasks &gt; Create bacpac\/dacpac (Preview)<\/strong>.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7988\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/tasks-context-menu-e1794960756224.webp\" alt=\"The database Tasks menu with Apply bacpac\/dacpac and Create bacpac\/dacpac highlighted.\" width=\"486\" height=\"547\" \/><figcaption>Start with the source database to create a file, or the target database to apply one.<\/figcaption><\/figure>\n<h3>Choose whether to include data<\/h3>\n<p>On <strong>Select Contents<\/strong>, confirm the source server and database. Leave <strong>Include data<\/strong> selected to create a BACPAC, or clear it to create a schema-only DACPAC. The wizard shows the resulting file format before you continue.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7985 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/create-select-contents-e1794961158288.webp\" alt=\"Select Contents with Include data selected and the file format shown as BACPAC.\" width=\"600\" height=\"442\" \/><figcaption>Include data selects BACPAC; schema only selects DACPAC.<\/figcaption><\/figure>\n<h3>Choose the file location<\/h3>\n<p>On <strong>Destination<\/strong>, choose <strong>Local disk<\/strong> or <strong>Azure Blob Storage<\/strong>. For a local file, enter a path or use <strong>Browse<\/strong>. For Blob Storage, connect to a storage account, select a container, and enter a file name. You need permission to read the source schema and data as applicable, and write access to the destination.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7996\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/create_2_destination-e1794962419532.webp\" alt=\"Destination step of creating a bacpac or dacpac.\" width=\"600\" height=\"442\" \/><figcaption>Choose the destination for the file.<\/figcaption><\/figure>\n<h3>Select the export settings<\/h3>\n<p>On <strong>Settings<\/strong>, a BACPAC export lets you choose which tables&#8217; data to include. Expand a schema to select individual tables, or use <strong>Select All<\/strong>. This table selection isn&#8217;t shown for a schema-only DACPAC.<\/p>\n<p>The <strong>Exclude Azure SQL Database Incompatible Objects<\/strong> option is also available. Select it if you want to exclude objects that aren&#8217;t compatible with Azure SQL Database.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7986 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/create-settings-e1794961194354.webp\" alt=\"Create Settings showing the compatibility option and tables grouped by schema for data export.\" width=\"600\" height=\"442\" \/><figcaption>Choose the table data to include in a BACPAC before starting the export.<\/figcaption><\/figure>\n<h3>Execute and monitor progress<\/h3>\n<p>Select <strong>Execute<\/strong> and review each operation&#8217;s status. Use <strong>Save Logs<\/strong> to keep the operation output, including any errors. When the file is created, <strong>Close<\/strong> finishes the workflow.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7997\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/create_4_execute-e1794962801180.webp\" alt=\"Execute step shows progress of the file creation.\" width=\"600\" height=\"442\" \/><figcaption>Execute shows the file creation progress.<\/figcaption><\/figure>\n<blockquote><p><strong>Protect the file:<\/strong> DACPAC and BACPAC files aren&#8217;t encrypted. Save them in a location with appropriate access controls, especially when they contain data.<\/p><\/blockquote>\n<h3>Optionally continue into Apply<\/h3>\n<p>If you want to use the file immediately, select <strong>Apply bacpac<\/strong> or <strong>Apply dacpac<\/strong> after creation succeeds. On <strong>Apply File<\/strong>, use <strong>Connect<\/strong> to connect to the target server and database, then select <strong>Start<\/strong>. The Apply wizard opens with the created file selected.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7984 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/create-apply-e1794961211441.webp\" alt=\"Apply File showing the exported BACPAC path and controls to connect to a target server.\" width=\"600\" height=\"442\" \/><figcaption>Applying the created file is optional. You can keep the file and apply it later instead.<\/figcaption><\/figure>\n<h2>Apply a DACPAC or BACPAC<\/h2>\n<p>To start with a file you already have, right-click the target database in <strong>Object Explorer<\/strong> and select <strong>Tasks &gt; Apply bacpac\/dacpac (Preview)<\/strong>. On <strong>Select Source<\/strong>, confirm the target, select <strong>Dacpac<\/strong> or <strong>Bacpac<\/strong>, and browse to the local file.<\/p>\n<p>Create and Apply support databases on SQL Server, Azure SQL Database, and Azure SQL Managed Instance. Your connection needs permissions for the operation. For a BACPAC, the target must have no user-defined objects; even an existing table with no rows prevents import. The wizard disables <strong>Bacpac<\/strong> when user objects are present.<\/p>\n<h3>DACPAC: configure the schema deployment<\/h3>\n<p>For a DACPAC, <strong>Options<\/strong> displays <strong>SQLCMD Variables<\/strong> and searchable <strong>Publish Options<\/strong>. Enter the variable values defined by the package and select the publish options for your target.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7982 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/apply-options-dacpac-sqlcmd-e1794961243121.webp\" alt=\"DACPAC Options showing editable SQLCMD variables and searchable Publish Options.\" width=\"600\" height=\"442\" \/><figcaption>Set SQLCMD variable values and review publish options before generating the deployment plan.<\/figcaption><\/figure>\n<p>Review <strong>Block on possible data loss<\/strong> before proceeding. Disabling it can allow changes that remove data. On <strong>Review Plan<\/strong>, inspect the planned changes and warnings before selecting <strong>Execute<\/strong>. Schema changes can create, alter, or drop objects. Back up the target before applying changes that could remove data.<\/p>\n<p>If the database already matches the DACPAC, the plan reports that no changes are needed.<\/p>\n<h3>BACPAC: configure the import<\/h3>\n<p>A BACPAC has its own <strong>Options<\/strong> page. Configure <strong>Command timeout<\/strong>, <strong>Long-running command timeout<\/strong>, and <strong>Database lock timeout<\/strong>, and use the search box to find <strong>Import Options<\/strong>.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7981 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/apply-options-bacpac-e1794961263428.webp\" alt=\"BACPAC Options showing timeout settings and searchable Import Options.\" width=\"600\" height=\"442\" \/><figcaption>BACPAC imports use timeout and import settings rather than DACPAC publish settings.<\/figcaption><\/figure>\n<p>On <strong>Review Plan<\/strong>, check the tables and data sizes under <strong>Table data to import<\/strong>. The <strong>Total data<\/strong> value shows the amount of data to import. Select <strong>Execute<\/strong> when you&#8217;re ready.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7983 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/apply-review-plan-bacpac-e1794961278219.webp\" alt=\"Review Import Plan listing tables, individual data sizes, and the total data to import.\" width=\"600\" height=\"442\" \/><figcaption>Review the table data before importing the BACPAC into the empty database.<\/figcaption><\/figure>\n<p>For either format, the <strong>Progress<\/strong> page shows the status of each operation. Use <strong>Save Logs<\/strong> to capture the output. If an operation fails, review the error and logs before retrying.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7999\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/apply_4_progress-e1794963289499.webp\" alt=\"Progress screen shows the execution of steps.\" width=\"600\" height=\"442\" \/><figcaption>Monitor the progress of each step.<\/figcaption><\/figure>\n<h2>Need a new database first?<\/h2>\n<p>On SQL Server or Azure SQL Managed Instance, right-click the <strong>Databases<\/strong> folder and select <strong>Create database from bacpac\/dacpac (Preview)<\/strong>.<\/p>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" class=\"alignnone wp-image-7987 size-full\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/databases-context-menu.webp\" alt=\"The Databases context menu with Create database from bacpac\/dacpac selected.\" width=\"634\" height=\"294\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/databases-context-menu.webp 634w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/databases-context-menu-300x139.webp 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><figcaption>Create the target database, then continue into Apply.<\/figcaption><\/figure>\n<p>This opens the existing <strong>New Database<\/strong> dialog. Enter the database name and configure the owner, files, options, and filegroups.<\/p>\n<blockquote><p><strong>Be sure to select the collation defined in the DACPAC or BACPAC file.<\/strong><\/p><\/blockquote>\n<p>When you select <strong>OK<\/strong> and database creation succeeds, the Apply wizard opens with the new database selected.<\/p>\n<p>The remaining steps are the same Apply flow described above. Database creation is separate from applying the package: if you cancel Apply or the operation fails, the created database remains.<\/p>\n<p>This new-database command isn&#8217;t available for Azure SQL Database. For that target, create the database separately and run Apply against it.<\/p>\n<h2>Try the preview<\/h2>\n<p>Start with a development or test database and choose the task you need: save a schema, export schema and data, deploy a DACPAC, or import a BACPAC into an empty database.<\/p>\n<p>The step-by-step guides cover permissions, settings, and the full workflow:<\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/create-dacpac-bacpac\">Create a DACPAC or BACPAC file<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/apply-dacpac-bacpac\">Apply a DACPAC or BACPAC to an existing database<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/create-database-from-dacpac-bacpac\">Create a database from a DACPAC or BACPAC<\/a><\/li>\n<\/ul>\n<p>Tell us what works and where you run into problems through <a href=\"https:\/\/aka.ms\/ssms-feedback\">SSMS feedback<\/a>. Include the package format, target platform, and any relevant error details, but don&#8217;t include credentials or sensitive data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing options confusing? SQL Server Management Studio (SSMS) has new preview wizards that streamlines those tasks: Create bacpac\/dacpac and Apply bacpac\/dacpac. The Create wizard guides you through the process of generating [&hellip;]<\/p>\n","protected":false},"author":2903,"featured_media":81,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,92],"tags":[],"class_list":["post-7980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-devops"],"acf":[],"blog_post_summary":"<p>Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing options confusing? SQL Server Management Studio (SSMS) has new preview wizards that streamlines those tasks: Create bacpac\/dacpac and Apply bacpac\/dacpac. The Create wizard guides you through the process of generating [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7980","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\/2903"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=7980"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7980\/revisions"}],"predecessor-version":[{"id":8001,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7980\/revisions\/8001"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/81"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=7980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=7980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=7980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}