|
We have a database project in Visual Studio 2010. On our development server, I have created a couple of new tables (with some indexes, foreign keys, etc). How do I import this new table and associated indexes, keys etc into my database project?
(comments are locked)
|
|
I am not too sure about VS2010 with regard to reading objects out the database, or how you have your project setup, but I have written a Powershell script to read out the objects of a database for use with source control. It spits out a file for each object, you would then only need to create the table files using the SMO calls in my script. You can find the script here: Scripting DB Objects using Powershell An excellent script! Thanks
Feb 10 '11 at 02:19 AM
xnl28
(comments are locked)
|
|
Visual Studio 2010 has the ability to compare a database with the project. It's in the Data menu and the Schema Comparison option. After that it should be fairly self-explanatory.
(comments are locked)
|
