Database Reference
In-Depth Information
Figure 5.8
DAC property setting.
can be done with the Extract Data-Tier Application Wizard included in SSMS. he wizard
retrieves the database objects, validates the content, and packages the database objects into
a .bacpac ile.
1. To start SSMS, log on to your virtual machine,
myserver
. Press the
Windows Icon
key
and click the
SQL Server Management Studio
icon. Similar to Figure 5.2, enter your
login information to Windows Azure SQL Database and then click the
Connect
button.
2. After logging on to Windows Azure SQL Database, in Object Explorer, expand the
Databases
node, right click the database
Computer_Store
, select
Ta sk s
, and then
click
Extract Data-tier Application
.
3. On the Introduction page, click
Next
to go to the
Set Properties
page. On this page,
set the version to
1.0.0.1
as shown in Figure 5.8. You may also need to record the path
to where the packaged .bacpac ile is saved such as the one below:
C:\Users\student\Documents\SQL Server Management Studio\DAC Packages\
Computer_Store.dacpac
4. Click
Next
to review the summary information. Click
Next
again to start the extrac-
tion and validation process. If the process is successfully completed, click
Finish
.
TASK 2: DEPLOYING A DAC TO VISUAL STUDIO
In this task, you will irst create a DAC package from Windows Azure SQL Database. hen,
import the packaged database objects to Visual Studio for the application development. For
this task, assume that Visual Studio 2012 is installed on your local computer.