If you are already using Visual Studio 2010 for your database projects, you will be familiar with the benefits of creating and deploying your schemas to the server.
From SQL Server Data Tools:
Open the New Project dialog box
Under Installed Templates, click on SQL Server.
In the centre pane, you will notice the available list of project templates change and will see something similar to the following screenshot:
As you can see, we have the SSDT Database Project template. If this is the first time you have chosen this project type, you will see the following message appear:
You need to install a separate component to create database projects. Go ahead and click on the Install buton. This will open your default browser and take you to the page on the Microsoft site, as listed previously. Click on the link to download SQL Server Data Tools and the web installer will run. Follow the download and installation instructions and this will add the capability to allow you to...