Use dataTablesPattern parameter.

[g-galaz]

Hello, the SchemaZen application is so good. Thank you.

I have a problem. When I try to use the dataTablesPattern parameter, it does not work for me.

Maybe it's because I do not know how to use it.

Could you show a detailed example how to use it by command line.

I want you to generate a script for only some user tables, for example all those whose name contains the text 201807:

city201807Contry
xsdc201807_all
sicom_all_201807_tbl
...

All tablas like "201807"

When I try laike this:
C:>"C:\Program Files Portable\schemazen\SchemaZen.exe" script --server localhos
t --database CYBER_PRD --scriptDir "C:\Program Files Portable\schemazen\salida21
" --overwrite --dataTablesPattern 201807

The system response that:
parsing "201807" - Quantifier {x,y} following nothing.

And the same response for:
C:>"C:\Program Files Portable\schemazen\SchemaZen.exe" script --server localhos
t --database CYBER_PRD --scriptDir "C:\Program Files Portable\schemazen\salida21
" --overwrite --dataTablesPattern "201807"

parsing "201807" - Quantifier {x,y} following nothing.

I tried using the another dataTables parameter by placing the name of the tables, separated by a comma, but it did not work either.

C:>"C:\Program Files Portable\schemazen\SchemaZen.exe" script --server localhos
t --database CYBER_PRD --scriptDir "C:\Program Files Portable\schemazen\salida31
" --overwrite --dataTables down6Acu_20180720,down6Acu_20180722,down6Acu_20180723

Exporting data...

If chack the path C:\Program Files Portable\schemazen\salida31 I have all the tables of data base,

Thanks for you help.

[jhelmink]

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