How to use

Please perform the installation steps before going ahead. Please note that user guide is currently provided only for windows users, unix user can prepare shell scripts to perform the same tasks. Please go through FAQ section to know more details.

Preparation of excel file

Excel file template (All.xls) has been provided in /excel folder which is self explainatory.

SQL scripts generation

Set of commads are provided for ease of usage. SQL files will be generated in sql folder by default.Please follow the following steps:
  • Once installation is done as per steps mentioned click on ScriptsFromExcelPerTable.cmd to generate SQL script file per table. You can edit the command file to generate SQL for any other excel file.
     
  • Click on ScriptsFromExcel.cmd to generate consolidate scripts for all sheets in excel file.

Excel file generation

Set of commads are provided for ease of usage. Excel files will be generated in excel folder by default. Please follow the following steps:
  • Once installation is done as per steps mentioned click on ExcelForTable.cmd to generate excel file for a single table. You can edit the command file to generate Excel for any other table.
     
  • Click on ExcelForSchema.cmd to generate excel files for whole schema. Please note that if you have more than 250 tables in the schema, then muliple excel files will be generated.
     
  • Click on ExcelForModule.cmd to generate scripts for a particular module as configured in DBMM_DB_MODULE_MASTER and DBTCM_DB_TABLE_CONFGRN_MASTER tables.
     
  • Click on ExcelForTableType.cmd to generate scripts for a particular table type as configured in DBTTM_DB_TABLE_TYPE_MASTER and DBTCM_DB_TABLE_CONFGRN_MASTER tables.