Any possibility to create project from a DB, and then commit changes to Schema Objects

Hello everybody,
perhaps a silly question, but there's a way to create a Database Project from an existing DB (e.g. Northwind :)), adding Schema Objects, and then "commit" them to the DB?
If so, IMHO it should be added to creation wizard.
If not, there's a "quick" way to create a Schema Object (e.g. a stored procedure), and insert it in a target DB?

[394 byte] By [paolod] at [2008-2-10]
# 1

OK, as not said.... :)

http://blogs.msdn.com/camerons/

paolod at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

So the "commit" can be done two ways. 1 you can run a schema compare from your project to the database. This will produce a script and you can either select the "update" button which will commit the changes or just output the change script and then run it separately.

You can also setup the build settings as Cameron showed in his blog. This is essentially wrapping around the compare facilities.

ThomasMurphy at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified