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.
How To topics in this section contain a series of tasks that can be completed in a sequence.
In This Section
Describes importing objects from a live database, .dacpac, or script.
Describes various ways to add a database reference.
Describes how SQL Server Data Tools can check for product updates.
Describes various project settings to control aspects of your database and build configurations.
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.
Describes the Data Tools Operations window, which shows the progress of some operations and notifies you of any errors.
Describes Transact-SQL options.
Create a database project and import existing database schema.
Compare the schemas of a database and a project and sync up.
Use the local on-demand SQL Server instance, which is activated when you debug a database project.
Change the target SQL Server platform for your project to any supported instance of SQL Server and validate syntax.
Create a read-only proxy of the database schema, and revert the source project when unwanted changes are applied to the project.
Add a new Sequence object to your project.
Create and publish CLR objects in the SQL Server Data Tools Database project.
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.
Discusses how to use scripts that you want to run before or after the deployment of your database.