⑤关于mssql转mysql
㈠MySQL-Migration-Toolkit
㈡Mssql to Access then access to MySQL
㈢BCP then Load data local infile txt into table xx;
Win(mssql) cmd执行
bcp "select * from http://www.doczj.com/doc/8c973dff83c4bb4cf6ecd103.html" queryout info.txt -c -x -S127.0.0.1 -Usa -P123.456 或者
bcp http://www.doczj.com/doc/8c973dff83c4bb4cf6ecd103.html out info.txt -c -x -S127.0.0.1 -Usa -P1 23.456
Fedora(MySQL)执行
mysql -u root -p
use test;
Load data local infile "/home/info.txt" into table xx;