Database Reference
In-Depth Information
Figure 5.9
Log on to Visual Studio 2012.
1. You may need to download and install the new Microsoft SQL Server Data Tools 2012
on your virtual machine if your Visual Studio does not already include the tool. he
SQL Server Data Tools can be downloaded from the following website: http://visual-
studiogallery.msdn.microsoft.com/96a2f8cc-0c8b-47dd-93cd-1e8e9f34a917
After the SQL Server Data Tools have been installed, click the
Restart
button.
2. To open Microsoft Visual Studio, press the
Windows Icon
key to open the tile. hen,
right-click
Visual Studio 2012
and choose
Run as administrator
as shown in Figure 5.9.
3. Click
New Project
. In the New Project dialog, expand the
Other Languages
node in
the Installed Templates pane and then click the
SQL Server
node. Enter the project
name as
Computer_Store_DB
shown in Figure 5.10 and click
OK
.
4. After the project is opened, click the
PROJECT
menu and select
Import
. hen, select
Data-tier Application
as shown in Figure 5.11.
5. On the Import Data-tier Application File page, click the
Browse
button next to the
Data-tier Application textbox. Navigate to the folder
C:\Users\student\Documents\SQL Server Management Studio\DAC Packages\
Computer_Store.dacpac
where the packaged ile is located. Click
Open
to import the ile shown in Figure 5.12.
Click
Start
to begin the import process.
6. hen, click
Finish
. To view the imported items, click the drop-down list with a arrow
on the menu bar and select
Computer_Store_DB
as shown in Figure 5.13. Expand
the dbo node, and then double click
CUSTOMER.sql
under the Tables node.
7. You should have the result shown in Figure 5.14.