1、定期导出逗号分隔的数据文件如*.csv格式,oracle侧sql脚本类似
set heading off
set termout off
set feedback off
set pagesize 0
set trimsout on
set trimspool on
spool test.csv
select t.id||','||col1||','||col2||','||col3 from test t where t.col1 between '080225' and '080301';
spool off
2、定期下载导出的文本文件test.csv,下载后删除。
3、在sqlserver中使用
BULK INSERT test FROM 'c:\test.csv' WITH (FIELDTERMINATOR = ',')