-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathREADME
83 lines (69 loc) · 2.41 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
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
<<<<<<< HEAD
openLogFile=false
delayTime=5000
=======
#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
>>>>>>> 4716c4ec1356a0fc9f9360b8a6cc28aba72dc344
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
<<<<<<< HEAD
fromDbUrl=jdbc:mysql://localhost:3306/test
fromDbUsername=root
fromDbPassword=lishunli
toDbDriver=com.mysql.jdbc.Driver
toDbUrl=jdbc:mysql://localhost:3306/test1
toDbUsername=root
toDbPassword=lishunli
criteria=student
openLogFile=false
delayTime=5000
If you have any questions,please contact me(weibo: http://weibo.com/lishunli or qq: 506817493 or email: [email protected]).
=======
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: [email protected]).
>>>>>>> 4716c4ec1356a0fc9f9360b8a6cc28aba72dc344