How to: Create Empty Database and Server Projects
When you create a database project or server project, you usually use the New Project Wizard not only to create the project but also to import objects and settings into it. However, you can just create an empty project if, for example, you will build your objects or settings in the project, instead of importing them. You might also create an empty project if you plan to import objects and settings later or you do not have permission to import them. For information about how to use the New Project Wizard, see How to: Create Database and Server Projects.
To create a project and a solution at the same time
On the File menu, point to New, and click Project.
The New Project dialog box appears.
Under Project Types, expand the Database Projects node, and click the node that corresponds to the version of the database or server that you want to manage.
For example, click SQL Server 2008 to manage changes to a server or database that is based on SQL Server 2008.
Under Templates, click the icon that corresponds to the type of project (database or server) and the version of SQL Server that you want to target.
Note
You can also change the target database version later. For more information, see How to: Change the Target Database Version.
In Name, type a name for this project.
In Location, type the location where the project will reside on the local computer, or click Browse to search for the location.
In Solution Name, type a name for the solution that will contain this project.
Select the Add to Source Control check box if you want to add the initial solution and project to version control.
Note
You can add the project to version control later. For more information, see How to: Add a Project or Solution to Version Control.
Click OK to create the solution and project.
The newly created solution and the project appear in Solution Explorer. You can import objects and settings from an existing database, import objects from a database script, or define objects. For more information, see How to: Import Database Objects and Settings, How to: Import Database Objects from a Script, or Scenario: Create and Modify Database and Server Objects.
To create a project in an existing solution
On the File menu, point to Add, and click NewProject.
The Add Project dialog box appears.
Under Project Types, expand the Database Projects node, and click the node that corresponds to the version of the database or server that you want to manage.
For example, click SQL Server 2008 to manage changes to a server or database that is based on SQL Server 2008.
Under Templates, click the icon that corresponds to the type of project (database or server) and the version of SQL Server that you want to target.
Note
You can also change the target database version later. For more information, see How to: Change the Target Database Version.
In Name, type a name for this project.
In Location, type the location where the project will reside on the local computer, or click Browse to search for the location.
Click OK to create the project.
The newly created solution and the project appear in Solution Explorer. You can import objects and settings from an existing database, import objects from a database script, or define objects. For more information, see How to: Import Database Objects and Settings, How to: Import Database Objects from a Script, or Scenario: Create and Modify Database and Server Objects.
See Also
Tasks
How to: Create Database and Server Projects
Walkthrough: Create and Deploy a New Version-Controlled Database
Concepts
Performing Iterative Database Development