It generates 'insert' DML from database, and now only Oracle, Tibero, and PostgreSQL are allowed. If you want to add another dbms, you have to modify followed source file: ProcessHandler.java, DmlWriterFactory.java
- Steps
- You need to create a file and fill out the configuration information in it. You can refer to config/database.properties file in this project.
In the configuration file, 6 information are required as below:
- driverClassName : Information of DBMS which you want to export from. (Ex. oracle.jdbc.driver.OracleDriver)
- url : Information of DBMS which you want to export from. (Ex. jdbc:oracle:thin:@192.168.102.101:1521:orcl)
- username : Information of DBMS which you want to export from. (Ex. scott)
- password : Information of DBMS which you want to export from. (Ex. tiger)
- result-file-path : Full path of DML result file. (Ex. C:\result.txt)
- table : Information of tables which you want to export from. (Ex. BOOK, USER)
- You need to declare the configuration file path at 'configFilePath' in DmlExportMain.
- You can check the result of DML in the result-file as you declared in the configuration file.