TableDataCopier

+ What do?
- copy table's data from one database to another database(same table schema)

+ Environment
- JDK 1.6 or above
- Only support oracle and mysql Driver DB.

+ Samples
- Oracle
### config.properties ###
### you can put config.properties into folder which containing the exe or jar file, or manual input. ###
fromDbDriver=oracle.jdbc.driver.OracleDriver
fromDbUrl=jdbc:oracle:thin:@${ip}:${port}:${sid}
fromDbUsername=username
fromDbPassword=password
toDbDriver=oracle.jdbc.driver.OracleDriver
toDbUrl=jdbc:oracle:thin:@${ip}:${port}:${sid}
toDbUsername=username
toDbPassword=password
criteria=table name or criteria

#when occurred error,must open log file.
openLogFile=false
#delay Time To Open Log(ms)
delayTime=5000

#Is Delete Original Data
deleteOriginalData=false

#Abort When Abnormal Copy
abort=false

Note: support connect by Oracle Service name. in this case, those URL will tuning as:
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=${ip})(PORT=${port}))(CONNECT_DATA=(SERVICE_NAME=${service_name})))
and please according to your own environment to reconfigure @${ip},${port},${sid},${service_name} or others

- Mysql
### Ditto ###
fromDbDriver=com.mysql.jdbc.Driver
fromDbUrl=jdbc:mysql://@${ip}:${port}/${db}
fromDbUsername=username
fromDbPassword=password
toDbDriver=com.mysql.jdbc.Driver
toDbUrl=jdbc:mysql://@${ip}:${port}/${db}
toDbUsername=username
toDbPassword=password
criteria=table name or criteria

#when occurred error,must open log file.
openLogFile=false
#delay Time To Open Log(ms)
delayTime=5000

#Is Delete Original Data
deleteOriginalData=false

#Abort When Abnormal Copy
abort=false

If you have any questions,please contact me(weibo: http://weibo.com/lishunli or twitter: https://twitter.com/lishunli or email: lishunli.me@gmail.com).