Sync Extended properties on the database itself

breninfl

I didn't find a matching post, so if this is a duplicate, please let me know. I'm trying to document my dbs using extended properties, and of course, for this to work, I'll need to sync across all the copies from dev, test, and production. I'm not finding any options in the sql compare to find these and create the script. Tables, views, etc. have the extended properties, but it's not listing the differences on the db itself.
Any suggestions?

Brian Donahue

Database-level extended properties are supported by SQL Compare since (I believe) version 8. For instance, this will show up as an extended property difference in SQL Compare:

EXEC sp_addextendedproperty N'MyPropTest', N'testytest', NULL, NULL, NULL, NULL, NULL, NULL

Have you got an example of a script to create a database-level property that isn't being detected and/or scripted by SQL Compare?

breninfl

I found it in the interface! Thanks so much.