Sync Extended properties on the database itself

breninflbreninfl Posts: 5
edited April 18, 2014 11:17AM in SQL Compare Previous Versions
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?
Brenda, another Red Gate Fan


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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?
  • Options
    I found it in the interface! Thanks so much.
    Brenda, another Red Gate Fan
Sign In or Register to comment.