Extracting the Source Azure SQL Data Layer Using SSMS

Procedure

1. Use SSMS to connect to Azure SQL, open Databases, right-click the smsa database, and choose Tasks > Extract Data-tier Application. The Extract Data-tier Application page is displayed.
   Figure 1 Accessing the application operation page
   

2. On the Introduction page, click Next to skip the page.
   Figure 2 Introduction
   

3. On the Set Properties page, select the path for saving the DAC file, and click Next.
   Figure 3 Set Properties
   

4. This page displays the basic information about the resource to be exported and the path for storing the exported file. If the information does not meet the expectation, click <Previous to reconfigure the export options. Click Next. The export execution page is displayed.
   Figure 4 Export page
   

5. This page displays the result of the export operation. After the DAC package file is created and saved successfully, click Finish to close the export page.
   Figure 5 Closing the export page
   

6. The exported file is displayed.
   Figure 6 Exported file display