Access "Pros and cons of the DACPAC with SQL Server 2008 R2"
This article is part of the August 2010, Vol. 3 issue of Exploring SQL Azure features and opportunities
Microsoft has combined SQL Server 2008 R2 and Visual Studio 2010 to give us a new feature called data-tier applications, or DACs. Deployment of DACs from Visual Studio into SQL Server is done through a data-tier application package, also known as a DACPAC. The good DACPACs are great for small shops that are deploying minor application changes to SQL Server. It allows the code to be kept within the existing source control and gives developers an easy way to edit SQL Server objects from within the already familiar Visual Studio environment. This means that developers can work against their development database for all their coding, and then package up all the changes into a single DACPAC for release to production. The DACPAC can also be handed off to a DBA for release into a production or quality assurance (QA) environment. The DACPAC handles versioning of the database through data-tier editing, providing the developer with an easy way to use the database editing system. The .NET developer has the ability to edit the tables, procedures, views, and functions of... Access >>>
Premium Content for Free.
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
Are we there yet? The slow road to SQL Azure
by Eric Johnson, SQL Server MVP
SQL Azure offers full-blown SQL Server functionality in the cloud and could ease management and development. But whether it’s ready to fully replace SQL Server remains to be seen.
- Where to look next for BI applications? Try the cloud by Roman Rehak, Contributor
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.
- Pros and cons of the DACPAC with SQL Server 2008 R2 by Denny Cherry, Contributor
More Premium Content Accessible For Free
Today, business analytics is largely focused on self-service software and pushing business intelligence capabilities down to the end user. In this ...
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...