导出时用SQL语句来导源数据试试。例: 2000000的数据分两次导。
1: select top 1000000 * from 表
2: select top 1000000 * from (select 2000000 * from 表 order by id) order by id desc
1: select top 1000000 * from 表
2: select top 1000000 * from (select 2000000 * from 表 order by id) order by id desc
内存消耗是不是太大了?