Extended Properties not in Visual Studio DB Projects?

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.

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.