4

Maybe it's me, hopefully I am missing something.

I added some Extended Properties to tables and columns in my MSSQL 2008 database. In Visual Studio 2010 I created a new database project, ran a "schema comparison" to load the DB into my project, and it didn't pick up the Extended Properties.

Can anyone comment on what I might have done wrong?

Thanks.

Snowy
  • 5,942
  • 19
  • 65
  • 119

1 Answers1

7

I believe extended properties are ignored by default in schema comparisons. You can include them by opening the "Schema Compare Options" dialog, select the Object Types tab, and ensure the Extended Properties checkbox is checked. Click OK. The comparison should now include extended properties.

You can also change the default settings for subsequently created comparisons by going to Tools -> Options -> Database Tools -> Schema Compare. That'll give you the same dialog as above.

Aaroninus
  • 1,062
  • 2
  • 17
  • 35
Brian Knight
  • 4,970
  • 28
  • 34
  • Unfortunately, [default options for schema compare have been removed in Visual Studio 2013](http://stackoverflow.com/q/19758972/3271599) – Aaroninus Apr 15 '15 at 12:54