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.
Search WWH ::




Custom Search