Database Reference
In-Depth Information
In this recipe, we will go through the required steps in order to design and manage data-tier
applications in the data platform.
Getting ready
There are no specific hardware or software requirements for data-tier applications except that
the SQL Server version must be 2008 R2. Additionally, the data-tier applications can be used
to work with existing databases using SSMS or used to implement new projects and releases
using Visual Studio 2010.
F
A DAC-in-place application can be created by registering the database as a data-tier
application, by using the Register Data-tier Application Wizard in SSMS or through
PowerShell snippets
F
Users can then extract each database to produce a DAC package for further
development where developers can use Visual Studio to author data-tier changes to
package them accordingly
F
The authorized packages can be re-deployed in the production by the DBAs using the
upgrade method from SSMS using automatic methods and tools that are available for
the data-tier application framework
F
In the case of new projects, the developers can create a new data-tier application
project in Visual Studio and build the DAC package for each application, then these
packages are forwarded to DBAs for deployment
F
For more information on new projects and deployment processes refer to the
Working
with
data-tier
applications
recipe, mentioned in
Chapter
1
.
F
In this recipe, we will use the SSMS tool to invoke the Deploy Data-tier Application
Wizard for the applications that are installed for the first time
DACPAC is suitable for smaller databases having frequent
release changes with limited structures and few features,
such as SQLCLR, Service Broker, and security.
How to do it...
In order to design and manage the upgrade of data-tier applications using the SSMS tool, you
will need to complete the following steps:
1. Locate the DAC package file that needs to be deployed.
2. InSSMS under the Object Explorer pane, select the node of the target instance of
SQL Server on which the new DAC package will be deployed and create a
new database.
Search WWH ::
Custom Search