如何用SQL2000的BCP工具倒入SQL6.5数据到MSSQLSERVER 2000

--migration data from MSSQLSERVER 6.5 TO SQLSERVER2000
--EXECUTE IN SQLSERVER6.5
BCP DB_NAME..TABLENAME OUT FILENAME.OUT -n -Usa -P -Sservername
--EXECUTE IN SQLSERVER2000
BCP DB_NAME..TABLENAME IN FILENAME.OUT -n -C1252 -V 65 -Usa -P -Sservername

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus