看sqlserver帮助,那里有异构查询的例子,至于分批操作,按天,按种类分割具体按实际情况不就是
第一批
insert into your desttable select * from sourctable
where sourcetable.date>='20030401' and sourcetable.date<='20030430'
第二批
insert into your desttable select * from sourctable
where sourcetable.date>='20030501' and sourcetable.date<='20030530'
....
批更新查ado参考手册