schemazen icon indicating copy to clipboard operation
schemazen copied to clipboard

script --dataTablesPattern option unable to filter

Open onguarde opened this issue 6 years ago • 2 comments
trafficstars

I have tables schema "Hangfire". Example, "HangFire.Job". I'm unable to filter these tables using the --dataTablesPattern option.

Here is what i've tried,

--dataTablesExcludePattern="(Job)" This works to filter out Job table. Program seems to be ignoring the schema portion of the table name. eg. dbo

Is there a way to specifically exclude ALL tables with a particular schema? --dataTablesExcludePattern="(Hangfire)"

onguarde avatar Nov 05 '19 10:11 onguarde

dataTablesPattern is expecting a regex expression; --dataTablesPattern "^(?!ignoreMe|ignoreMeToo|ignoreAnotherOne$).*"

Not sure that it handles the schema though.

jhelmink avatar Apr 03 '20 04:04 jhelmink

Only just saw this issue now, but my PR to specify schemas should help with this - https://github.com/sethreno/schemazen/pull/193

rhumborl avatar Jul 03 '21 12:07 rhumborl