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

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

  • Thursday, June 15, 2006 8:20 PM
     
     

    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?

All Replies

  • Thursday, June 15, 2006 9:06 PM
     
     

    OK, as not said.... :)

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

  • Monday, June 26, 2006 4:42 PM
     
     Answered

    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.