Chapter 6. Using Visual Studio with SQL Server
In This Chapter
Installing SQL Server 2008 Express Edition
Configuring the Adventure Works sample database
Creating scripts in database projects
Creating stored procedures in SQL Server projects
Using Visual Database Tools
Most useful programs require some kind of data storage. Often, that's a database program like Microsoft SQL Server. SQL Server 2008 is the latest release of the popular database program and ships with Visual Studio 2010.
This chapter shows you how to install SQL Server 2008 and how to use Visual Studio to create and manage database objects.
Getting Acquainted with SQL Server 2008
SQL Server 2008 is the latest version of the popular Microsoft database management system. Each edition of Visual Studio includes a license for one of the editions of SQL Server 2008. Table 6-1 lists the editions of SQL Server and describes how to get the program.
Table 6-1. SQL Server Editions
SQL Server Version | When to Use It | How to Get It |
|---|---|---|
Enterprise Edition | In large companies | Purchase separately; retail price $24,999 |
Standard Edition | In small- and medium-size businesses | Purchase separately; retail price $5,999 |
Workgroup Edition | In departments or branch offices | Purchase separately; retail price $3,899 |
Express Edition | For prototypes or local development | Free download from Microsoft Web site; included with all Visual Studio Express Editions and Visual Studio Standard Editions |
Developer Edition | For prototypes or local development | Included with Professional, Tools for ... |
Get Visual Studio® 2010 All-in-One For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
