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.
Note
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. |
| 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. |
Related Sections
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for