Databases Reference
In-Depth Information
Once the export has completed successfully, click Close. At this point, you have a BACPAC that you can then
import to one or multiple SQL Azure servers. Granted, you can't import to multiple SQL Azure servers simultaneously,
but unlike the Deploy Database to SQL Azure option, with the Export and Import functionality, you can import the
BACPAC multiple times without rerunning the export step again. It's now time to import that DAC package (BACPAC)
to SQL Azure.
DAC Import
Connect to your SQL Azure server in SQL Server Management Studio, and in the Object Explorer window right-click
the Databases node and select Import Data-Tier Application from the context menu (see Figure
4-7
), which will start
the Import Data-Tier Application Wizard.
Figure 4-7.
DAC Import menu option
Click Next on the Introduction page of the wizard. In the Import Settings page of the wizard, shown in Figure
4-8
,
notice that you have two options; Import from Local Disk and Import from Windows Azure. We saved our DAC file to
a local directory, so select the Import from Local Disk option, browse to the location of the DAC package (BACPAC)
that you exported in the previous step, and then click Next.
