Include only a specific security schema on database compare
priyasinha
Redgate › Posts: 548 Silver 1
Note: This issues has been migrated from ReadyRoll support forum
Is there a way to limit the dbsync tool database compare to only a single security schema? We have many applications in a single database grouped by security schema.
Example:
Database1
-Application1.Table1
-Application1.Table2
-Application2.AnotherTable
I'd like to only include Application1 in my readyroll project and ignore any changes to the Application2 security schema. Is this possible?
Is there a way to limit the dbsync tool database compare to only a single security schema? We have many applications in a single database grouped by security schema.
Example:
Database1
-Application1.Table1
-Application1.Table2
-Application2.AnotherTable
I'd like to only include Application1 in my readyroll project and ignore any changes to the Application2 security schema. Is this possible?
Priya Sinha
Project Manager
Red Gate Software
Project Manager
Red Gate Software
Comments
However we do have a way to exclude objects from compare by schema name, using regular expressions:
https://documentation.red-gate.com/disp ... se+Objects
Unfortunately you’d need to add the full list of irrelevant schema names in order to get it to include just the one you want; I realise that wasn’t quite what you were after but hopefully this is of some use to you.
Project Manager
Red Gate Software