Database first database projects

Question

Hi Allm

I have been working on a new project for a little while and already have the Database in sqlServer2008. I would like to put the DB into a database project to make installation better.

Is there a way to import an exisiting database into a DB project?

Thanks,

EDIT: This is in VisualStudio 2010 btw... oops!

Answer 1

You can start a new SQL Server 2008 database project.

In the Schema View window, choose the command to Import Database Objects And Settings. From there, you'll be asked to choose a database from Server Explorer, or you can browse, provide a connection string, etc.

If this is not what you're looking for, please leave a comment, and we can get it sorted out!