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.

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?

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: 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.

Regards

John

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:
http://support.ready-roll.com/customer/portal/questions/1357719-ignoring-database-tables-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.

Best Regards,

Daniel

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.

https://readyroll.uservoice.com/forums/204125-readyroll-product-feedback/suggestions/11545749-limit-dbsync-compare-to-a-single-schema

This question has received the maximum number of answers.

readyroll.support@red-gate.com
http://assets0.desk.com/
false
readyrollsql
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete