How to create database project from existing SQL Server database?

By using VS TFS Dat开发者_如何学运维abase Edition 2008, how to create dbproject from an existing SQL SERVER database?

This as updated in VS 2010. There is now the option to "Import database objects and settings" from the project context menu.

In "Visual Studio" go to the "SQL Server Object Explorer" locate to database, right-click on the database you want and select "Create New Project ..."

There no direct, built-in support to do that, unfortunately.

You can get close by doing this:

• in SQL Server Management Studio, go to the Object Explorer, right-click on the database you want, and pick Tasks > Generate Scripts
• select all the database objects you want to script out
• at the end, choose to generate the scripts into separate files for each db object

What you end up with are a number of .sql scripts in a folder of your choice, which basically represent your database.

Next:

• create a Database Project in Visual Studio 2008
• once you've done that, add the existing scripts to that project

It's a bit more involved that it should be - but that's the only way that I know of to achieve this right now. Don't know if VS2010 will support this in an easier way....