mysqldump有一个参数,可以设置为mssql,您可以试一试,看能否导出到mssql,末学没有试过,不知道行不行 --compatible=name Change the dump to be compatible with a given mode. By default tables are dumped in a format optimized for MySQL. Legal modes are: ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, no_field_options. One can use several modes separated by commas. Note: Requires MySQL server version 4.1.0 or higher. This option is ignored with earlier server versions.试一试,下面的备份test资料库到mssql格式 mysqldump -uroot -h127.0.0.1 -p --lock-all-tables --add-drop-database --add-drop-table --comments --complete-insert --default-character-set=utf8 --compatible=mssql --result-file=c:\test.sql test
Navicat for mysql 选择导出为*.sql 文件 对创建表的语句稍作必要修改后执行……
主键、外键、索引、约束、SP、TRIGGER之类的,工作量比较大
--compatible=name Change the dump to be compatible with a given mode. By
default tables are dumped in a format optimized for
MySQL. Legal modes are: ansi, mysql323, mysql40,
postgresql, oracle, mssql, db2, maxdb, no_key_options,
no_table_options, no_field_options. One can use several
modes separated by commas. Note: Requires MySQL server
version 4.1.0 or higher. This option is ignored with
earlier server versions.试一试,下面的备份test资料库到mssql格式
mysqldump -uroot -h127.0.0.1 -p --lock-all-tables --add-drop-database --add-drop-table --comments --complete-insert --default-character-set=utf8 --compatible=mssql --result-file=c:\test.sql test
选择导出为*.sql 文件
对创建表的语句稍作必要修改后执行……