Project-Oriented Offline Database Development

 

This section describes features provided by SQL Server Data Tools (SSDT) for authoring, building, debugging and publishing a database project.

Using SSDT, you can create an offline database project and implement schema changes by adding, modifying or deleting the definitions of objects (represented by scripts) in the project, without a connection to a server instance. These can all be accomplished by using the table designer, or the Transact-SQL Editor. You can also write and debug Transact-SQL and CLR objects in the same project. You can use Schema Compare to ensure that your project stays in sync with the production database, and create snapshots for your project in each stage of the development cycle for comparison purposes. While you are working on your database projects in a team-based environment, you can employ version control for all the files. After your database project has been developed, tested and debugged, you can hand off your project to authorized personnel to be published to a production environment.

System_CAPS_noteNote

How To topics in this section contain a series of tasks that can be completed in a sequence.

In This Section

Topic

Description

Import into a Database Project

Describes importing objects from a live database, .dacpac, or script.

Add Database Reference Dialog Box

Describes various ways to add a database reference.

Check for Updates Dialog Box

Describes how SQL Server Data Tools can check for product updates.

Database Project Settings

Describes various project settings to control aspects of your database and build configurations.

How to: Browse Objects in a SQL Server Database Project

The SQL Server Object Explorer in Visual Studio now contains a dedicated Projects node, under which all SQL Server database projects in your solution are grouped in an SQL Server Management Studio-like hierarchy.

Data Tools Operations Window

Describes the Data Tools Operations window, which shows the progress of some operations and notifies you of any errors.

Transact-SQL Editor Options

Describes Transact-SQL options.

How to: Create a New Database Project

Create a database project and import existing database schema.

How to: Use Schema Compare to Compare Different Database Definitions

Compare the schemas of a database and a project and sync up.

How to: Build and Deploy to a Local Database

Use the local on-demand SQL Server instance, which is activated when you debug a database project.

How to: Change Target Platform and Publish a Database Project

Change the target SQL Server platform for your project to any supported instance of SQL Server and validate syntax.

How to: Create a Snapshot of a Project

Create a read-only proxy of the database schema, and revert the source project when unwanted changes are applied to the project.

How to: Use Microsoft SQL Server 2012 Objects in Your Project

Add a new Sequence object to your project.

How to: Work with CLR Database Objects

Create and publish CLR objects in the SQL Server Data Tools Database project.

How to: Convert a Visual Studio 2010 Database Projects to SQL Server Database Projects and Retarget to a Different Platform

Convert existing SQL Server Database, CLR objects, and Data-Tier Application projects created in Visual Studio 2010 to the SQL Server Data Tools Database project.

How to: Specify Predeployment or Postdeployment Scripts

Discusses how to use scripts that you want to run before or after the deployment of your database.

Show: