How can we help you today? How can we help you today?

Sync Extended properties on the database itself

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?
breninfl
0

Comments

2 comments

Sort by
  • 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?
    Brian Donahue
    0
  • breninfl
    I found it in the interface! Thanks so much.
    breninfl
    0

Add comment

Please sign in to leave a comment.