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.
I'd like to only include Application1 in my readyroll project and ignore any changes to the Application2 security schema. Is this possible?
Thanks for getting in touch.
We don’t support this use case currently. However it is definitely a good suggestion. If you have time you might consider submitting it to our UserVoice site: https://readyroll.uservoice.com/forums/204125-readyroll-product-feedback.
I’m also going to bring in my colleague, Dan Nolan, who might have some additional suggestions as to how to handle working with multiple schema.
Just to add to John’s reply, we don’t currently have a way to specifically include a certain schema’s objects in a given project.
However we do have a way to exclude objects from compare by schema name, using regular expressions:
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.
This question has received the maximum number of answers.