Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Include only a specific security schema on database compare

Justin J Stark Jan 20, 2016 01:41AM AEDT

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?

Up 0 rated Down
John Walley Jan 20, 2016 05:00AM AEDT ReadyRoll Agent

Hi Justin,

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:

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.



Up 0 rated Down
Daniel Nolan Jan 22, 2016 10:16PM AEDT ReadyRoll Agent

Hi Justin,

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.

Best Regards,


Up 0 rated Down
Justin J Stark Jan 25, 2016 01:59PM AEDT
Thank you for your awesome replies. I went ahead and created a uservoice for my request.

This question has received the maximum number of answers.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found