Database Management

Rely on a DAC, an entity containing all the database and instance objects that an application uses. It is supported by interoperability with Visual Studio 2010.

Find out what’s inside

• Capture database application schema, such as tables and stored procedures.

• Meet application deployment requirements.

• Control SQL Server instance objects.

Provide a single unit of deployment

• Define application deployment requirements within the new project type.

• Use requirements as simple as “VersionMajor is greater than or equal to 10.”

• Include these requirements in the deployment package.

• Prevent information from getting lost in translation from development to IT.

Create a DAC

• Build a new DAC package in Visual Studio.

• Generate a DAC package file for an existing database with the Extract DAC Wizard.

A rich set of tools and wizards helps you quickly create reliable DAC applications.

Use Transact-SQL code snippets

• Streamline application development by using prewritten code snippets.

• Access on-the-fly lists of available objects and properties for each project through Transact-SQL IntelliSense.

Take advantage of Transact-SQL Static Code Analysis tools

• Enforce and provide guidance on coding standards out-of-the-box.

• Recognize the warnings and errors that help identify issues in code before it’s handed to database administrators.

• Debug erring stored procedures or functions deployed in a SQL Server instance from a project.

Extract a DAC

• Locate and package schema and other objects.

• Enable efficient utility registration and handoff to development.

Gain powerful tools

• Use built-in designers to create tables and views quickly.

• Write custom scripts with deployment actions and data manipulation operations.

Streamline DACs for moves, upgrades, and deployments. Speed up development time and improve collaboration with IT staff throughout the development cycle.

Accelerate deployments and upgrades

• Make needed changes, and hand off updated versions to IT by using familiar tools in Visual Studio 2010.

• Rely on a new wizard to access requirements, locate application objects, and perform upgrades.

• Save upgrade and development steps.

• Improve time-to-market.

Enjoy interoperability with Microsoft SQL Azure

• Access a scalable relational database platform and self-managed, highly available cloud service.

• Deploy packages directly to SQL Azure.

• Deploy on-premises or off-premises.

• Optimize resources across the environment, based on application needs and IT bandwidth.

Improve management with the Utility Explorer interface

• Display aggregated data and information across multiple computers and instances.

• Easily obtain utilization reports and statistics.

• Tune and control views showing DAC resource consumption.