E:\dbpress>sqluldr2 anysql/anysql query=tab text=mysqlins
INSERT INTO `tab` (`TNAME`,`TABTYPE`,`CLUSTERID`) VALUES
(unhex('4150505f43415445474f5259'),unhex('5441424c45'),null),
(unhex('4150505f444550454e4453'),unhex('5441424c45'),null),
......
(unhex('545f4d565445535432'),unhex('5441424c45'),null);
不管增加了多不功能,sqluldr2都保持了一如即往的导出性能,生成复杂INSERT语句的速度和直接导出文本一样快。
E:\dbpress>sqluldr2 anysql/anysql query=test3 text=mysqlins file=temp.txt
0 rows exported at 2012-05-17 08:38:51, size 0 MB.
1000000 rows exported at 2012-05-17 08:38:59, size 244 MB.
2000000 rows exported at 2012-05-17 08:39:11, size 492 MB.
3000000 rows exported at 2012-05-17 08:39:23, size 740 MB.
4000000 rows exported at 2012-05-17 08:39:37, size 984 MB.
4764032 rows exported at 2012-05-17 08:39:46, size 1175 MB.
output file temp.txt closed at 4764032 rows, size 1175 MB.
有了这个功能后,sqluldr2会成为最流行的从Oracle迁移数据到MySQL的工具。