Object Selection through Extended Property

NarasNaras Posts: 7 Bronze 2
edited September 9, 2009 3:51PM in SQL Compare Previous Versions
I need to compare only objects (Tables/Views/StoredProcedures...) belongs to our team in a databases. So we created extended property called 'Team' as Name and 'Team01' as value on our objects.

Using SQLCompare command line, can I use /Include switch to include only our objects like this?

/Include:ExtendedProperty:Team:Team01.

I tried, but I got an error stated that "Invalid value for switch".

RedGate Team/Forum Members:

Could you include this switch in new future releases? or
Is there any other way I can use SQLCompare to achieve the same results?.
Thanks
Naras.

Comments

  • Hi Naras,

    Thanks for your post.

    Currently SQL Compare will consider extended properties only as a property of the table and not as a separate entity, so /Include:ExtendedProperty won't work I'm afraid.

    I've added this feature request to the relevant issue in our system (SC-2447). It is definitely one of the more popular requests we have for SQL Compare (although more for triggers and indexes rather than extended properties). Unfortunately implementing this requires a major architectural change and I'm afraid I can't give you a timescale when this work might happen.

    Regards,

    Alice
    Red Gate Software
  • NarasNaras Posts: 7 Bronze 2
    Thanks Alice.

    I have resolved with using /Filter switch to select the objects through their names.
    If Extended Property is used to pull the objects is implemented, it is well and good.
    Thanks
    Naras.
Sign In or Register to comment.