Download Latest Version
DataMigrator-64bit-for-Oracle.zip (5.6 MB)
Get an email when there's a new version of Data Migrator for Oracle
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| MySQL-to-Oracle-DataMigrator1-64bit.zip | 2014-12-16 | 4.3 MB | |
| README.txt | 2014-12-16 | 30.7 kB | |
| MySQL-to-Oracle-DataMigrator1-32bit.zip | 2014-12-16 | 4.4 MB | |
| Totals: 3 Items | 8.7 MB | 0 | |
## ##dm32.exe -h ALL ---------------------------------------------------------------------- MySQL to Oracle DataMigrator (v1.23.9, beta, 2014/12/16 09:36:33) [32bit] Copyright (c): 2014 Alex Buzunov, All rigts reserved. Agreement: Use this tool at your own risk. Author is not liable for any damages or losses related to the use of this software. ---------------------------------------------------------------------- From MySQL: Set following command line arguments to copy from MySQL to Oracle: -w copy_vector -o pool_size -r num_of_shards -t field_term -l lame_duck -K keep_data_file -1 arg_1 -2 arg_2 -3 arg_3 -q query_sql_file -Q query_sql_dir -c from_table -P from_partition -S from_sub_partition -j from_user -x from_passwd -b from_db_name -n from_db_server -z source_client_home -g to_db -a to_table -e nls_date_format -m nls_timestamp_format -O nls_timestamp_tz_format -Z target_client_home Here: (Common) -w [--copy_vector] Data copy direction. (Common) -o [--pool_size] Pool size. (Common) -r [--num_of_shards] Number of shards. (Common) -t [--field_term] Field terminator. (Common) -l [--lame_duck] Limit rows (lame duck run). (Common) -K [--keep_data_file] Keep data dump. (Common) -1 [--arg_1] Generic string argument 1. (Common) -2 [--arg_2] Generic string argument 2. (Common) -3 [--arg_3] Generic string argument 3. (From MySQL) -q [--query_sql_file] Input file with MySQL query sql. (From MySQL) -Q [--query_sql_dir] Input file with MySQL query sql. (From MySQL) -c [--from_table] From table. (From MySQL) -P [--from_partition] From partition. (From MySQL) -S [--from_sub_partition] From sub-partition. (From MySQL) -j [--from_user] MySQL source user. (From MySQL) -x [--from_passwd] MySQL source user password. (From MySQL) -b [--from_db_name] MySQL source database. (From MySQL) -n [--from_db_server] MySQL source instance name. (From MySQL) -z [--source_client_home] Path to MySQL client home. (To Oracle) -g [--to_db] To Oracle database. (To Oracle) -a [--to_table] To Oracle table. (To Oracle) -e [--nls_date_format] nls_date_format for target. (To Oracle) -m [--nls_timestamp_format] nls_timestamp_format for target. (To Oracle) -O [--nls_timestamp_tz_format] nls_timestamp_tz_format for target. (To Oracle) -Z [--target_client_home] Path to Oracle client home bin dir. --USE CASES-- 1. MySQL_to_Oracle. 16 use cases. MySQL_to_Oracle: 16 use case(s) available: 1. MYSQL_Partition_Limit22_to_ORA_Table - Copy only 22 rows from MySQL partition into Oracle Table table. 2. MYSQL_Partition_to_ORA_Table - Copy MySQL partition into Oracle Table table. 3. MYSQL_QueryDir_Limit333_to_ORA_Table - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql". Copy only 333 rows from MySQL query results into Oracle Table table. 4. MYSQL_QueryDir_to_ORA_Table - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql". Copy MySQL query results into Oracle Table table. 5. MYSQL_QueryFile_Limit100_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql". Copy only 100 rows from MySQL query results into Oracle Table table. 6. MYSQL_QueryFile_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql". Copy MySQL query results into Oracle Table table. 7. MYSQL_ShardedPartition_to_ORA_Table - Break input sharded partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL sharded partition into Oracle Table table. 8. MYSQL_ShardedQuery_to_ORA_Table - Break input query results into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL query results into Oracle Table table. 9. MYSQL_ShardedSubpartition_to_ORA_Table - Break input sharded sub-partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL sharded sub-partition into Oracle Table table. 10. MYSQL_ShardedTable_to_ORA_Table - Break input table into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL table into Oracle Table table. 11. MYSQL_Subpartition_Limit33_to_ORA_Table - Copy only 33 rows from MySQL sub-partition into Oracle Table table. 12. MYSQL_Subpartition_to_ORA_Table - Copy MySQL sub-partition into Oracle Table table. 13. MYSQL_Table_KeepSpoolFile_to_ORA_Table - Copy MySQL table into Oracle Table table. 14. MYSQL_Table_Limit1000_to_ORA_Table - Copy only 1000 rows from MySQL table into Oracle Table table. 15. MYSQL_Table_to_ORA_Table - Copy MySQL table into Oracle Table table. 16. MYSQL_TimezoneQueryFile_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query_tz_to_ora.sql". Copy MySQL query results into Oracle Table table. --DETAILS-- -USE-CASE # 1 Use case name: MYSQL_Partition_Limit22_to_ORA_Table Description: Copy only 22 rows from MySQL partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 22 ^ -c TEST.Partitioned_test_from ^ -P rx2015 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 2 Use case name: MYSQL_Partition_to_ORA_Table Description: Copy MySQL partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c TEST.Partitioned_test_from ^ -P rx2015 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 3 Use case name: MYSQL_QueryDir_Limit333_to_ORA_Table Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql". Copy only 333 rows from MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -Q[--query_sql_dir] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 333 ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 4 Use case name: MYSQL_QueryDir_to_ORA_Table Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql". Copy MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -Q[--query_sql_dir] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_mysql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 5 Use case name: MYSQL_QueryFile_Limit100_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql". Copy only 100 rows from MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -q[--query_sql_file] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 100 ^ -q c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 6 Use case name: MYSQL_QueryFile_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql". Copy MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -q[--query_sql_file] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 7 Use case name: MYSQL_ShardedPartition_to_ORA_Table Description: Break input sharded partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL sharded partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -c TEST.Partitioned_test_from ^ -P rx2015 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 8 Use case name: MYSQL_ShardedQuery_to_ORA_Table Description: Break input query results into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -q[--query_sql_file] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\mysql_query.sql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 9 Use case name: MYSQL_ShardedSubpartition_to_ORA_Table Description: Break input sharded sub-partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL sharded sub-partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -c TEST.Sub_Partitioned_test_from ^ -S subpart200 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 10 Use case name: MYSQL_ShardedTable_to_ORA_Table Description: Break input table into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy MySQL table into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -c TEST.Timestamp_test_from ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 11 Use case name: MYSQL_Subpartition_Limit33_to_ORA_Table Description: Copy only 33 rows from MySQL sub-partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 33 ^ -c TEST.Sub_Partitioned_test_from ^ -S subpart200 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 12 Use case name: MYSQL_Subpartition_to_ORA_Table Description: Copy MySQL sub-partition into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c TEST.Sub_Partitioned_test_from ^ -S subpart200 ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 13 Use case name: MYSQL_Table_KeepSpoolFile_to_ORA_Table Description: Copy MySQL table into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -K[--keep_data_file] is "Keep data dump." -c[--from_table] is "From table." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -K 1 ^ -c TEST.Timestamp_test_from ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 14 Use case name: MYSQL_Table_Limit1000_to_ORA_Table Description: Copy only 1000 rows from MySQL table into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 1000 ^ -c TEST.Timestamp_test_from ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 15 Use case name: MYSQL_Table_to_ORA_Table Description: Copy MySQL table into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c TEST.Timestamp_test_from ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 16 Use case name: MYSQL_TimezoneQueryFile_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\mysql_query_tz_to_ora.sql". Copy MySQL query results into Oracle Table table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -q[--query_sql_file] is "Input file with MySQL query sql." -j[--from_user] is "MySQL source user." -x[--from_passwd] is "MySQL source user password." -b[--from_db_name] is "MySQL source database." -n[--from_db_server] is "MySQL source instance name." -z[--source_client_home] is "Path to MySQL client home." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141216_093633\dm32\dm32.exe ^ -w mysql2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\mysql_query_tz_to_ora.sql ^ -j "alex" ^ -x "mysql_pwd" ^ -b "test" ^ -n "localhost" ^ -z "C:\Temp\mysql\bin" ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timezone_test_to ^ -e "YYYY-MM-DD HH24.MI.SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF2" ^ -O "YYYY-MM-DD HH:MI:SS.FF2 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN"