Skip to main content
Version: Previous

DB Streaming out - advanced

The generateSQLToRDB script

generateSQLToRDB is a tool that generates .sql files to create tables and procedures in our RDBMS system by reading the current Genesis dictionary. It also adds the pertinent databaseStream configuration to the specified genesistodb.xml configuration file.

It is by no means mandatory, but it provides a generic, quick and working example that can be further modified or extended with ease. However, the Genesis dictionary must be appropriately configured beforehand: TABLENAME_BY_TIMESTAMP key must exist (as shown in previous section examples) inside the table, as well as having a key made of a unique field (e.g "ORDER_ID").

Usage:

generateSQLToRDB [options]
ArgumentArgument long nameMandatoryDescriptionRestricted values
-cfg --configFile <arg> Nogenesistodb config xml file to be modifiedNo
-dbName --databaseName <arg> Nothe database name for Oracle dbsNo
-dbType --databaseType <arg> Nothe database typeMSSQL, ORACLE or POSTGRES
-f --file <arg> Noname of the sql file to export tableNo
-h --help Noshow usage informationNo
-t --table <arg> Nothe name of the table to export to csvNo