Database Reference
In-Depth Information
The inter-operability with Visual Studio 2010 introduces the facility to create data-tier
applications using the project template. The internal components of Visual Studio 2010
distribute several database projects and templates to enable the users to develop the integral
part of applications for data-tier applications. These capabilities of Visual Studio 2010 and
SQL Server 2008 R2 reduce the trial and error associated with deployments streamlining
SQL Server consolidation initiatives; the control point also provides broad control over the
hardware utilization of the database environment. Using the most common applications,
such as SQL Server Management Studio (SSMS) and Visual Studio, the MSM component
can be deployed. SQL Server 2008 R2 SSMS includes a new explorer called Utility Control
Point explorer and interoperability with Visual Studio (VS) tool project type, which will help
developers to write database applications, capture deployment intent, and produce the
data-tier application as a single unit of deployment. In this recipe, we will go through the
implementation of the MSM feature with the help of tools, such as VS and SSMS by the
developers and DBAs.
How to do it...
To get started, let us go through the steps to implement the MSM feature using Visual Studio
tool that will deploy data-tier application components, which are important for database
applications deployment:
1. Open the Visual Studio programs from Start | programs | Visual Studio 2010
program group.
2. Click File, click New, and then click Project. Under Installed Templates, expand the
Database node, and then click on the SQL Server node.
3.
In the template pane, click SQL Server Data-tier Application. Then, type the
project
name
,
location
, and
solution
name
in the appropriate text boxes at the
bottom of the form.
4.
To use source control for database code, select the Add source control check box.
After all selections are entered, click OK to create the project.
Search WWH ::
Custom Search