schemazen
schemazen copied to clipboard
Use dataTablesPattern parameter.
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.
dataTablesPattern is expecting a regex expression;
--dataTablesPattern "^(?!ignoreMe|ignoreMeToo|ignoreAnotherOne$).*"