Extended properties not in Visual Studio DB projects?

Question

Maybe it's me, hope something is missing.

I added some advanced properties to the tables and columns in the MSSQL 2008 database. In Visual Studio 2010, I created a new database project, performed a “schema comparison” to load the database into my project, and did not get the extended properties.

Can someone comment on what I could have done wrong?

Thanks.

Answer 1

I believe that extended properties are ignored by default when comparing schemas. You can enable them by opening the Schema Comparison Options dialog box, select the Object Types tab, and select the Advanced Properties check box. Click OK. The comparison should now include advanced properties.

You can also change the default settings for subsequently created comparisons by choosing Tools → Options → Database Tools → Schema Comparison. This will give you the same dialog as above.