schemazen icon indicating copy to clipboard operation
schemazen copied to clipboard

Use dataTablesPattern parameter.

Open g-galaz opened this issue 6 years ago • 1 comments

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.

g-galaz avatar Jul 13 '18 16:07 g-galaz

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

jhelmink avatar Apr 03 '20 04:04 jhelmink