schemazen
schemazen copied to clipboard
script --dataTablesPattern option unable to filter
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)"
dataTablesPattern is expecting a regex expression;
--dataTablesPattern "^(?!ignoreMe|ignoreMeToo|ignoreAnotherOne$).*"
Not sure that it handles the schema though.
Only just saw this issue now, but my PR to specify schemas should help with this - https://github.com/sethreno/schemazen/pull/193