通过 phpMyAdmin 将数据库转储导出到 MS SQL
当我使用 phpMyAdmin 导出时，它有一个 MS SQL 导出兼容性选项。但是，生成的文件包含许多非 MS SQL 兼容项，例如mediumtext 和枚举数据类型。我该如何解决这个问题？
When I use the phpMyAdmin export, it has an option for MS SQL export compatibility. However, the resulting file includes many non-MS SQL compatible items, such as mediumtext and enum datatypes. How do I work around this issue?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
vs
查看两个文件之间的差异将向您展示一些需要检查的内容。
我希望这对一些人有帮助。
vs
Looking at the difference between the two files will show you some things to check out.
I hope that helps some.
如果您无法找到 phpMyAdmin 生成正确格式的导出文件的方法，那么您必须编辑生成的导出文件以使其与 MS SQL 兼容。例如，您可能需要使用正则表达式来替换 ENUM 数据类型。
如果您发现必须经常导出数据，您可能会发现编写一个可以根据需要重新运行的简短文本处理脚本会节省您的时间。
哦，请注意您的文本编辑器或最喜欢的脚本语言可以正确处理 phpMyAdmin 生成的文件的字符编码。
If you are unable to locate a way for phpMyAdmin to generate an exported file of the correct format, then you'll have to edit the resulting exported file to make it compatible with MS SQL. You may need to use regular expressions to, for example, replace ENUM datatypes.
If you find that you have to export data frequently, you may find that writing a short text processing script that you can re-run as needed will save you time.
Oh, and take care that your text editor or favorite scripting language can properly handle the character encoding of the file generated by phpMyAdmin.
该文档似乎非常结论性 - http://www.waynezim.com/2010/03/how-to-export-mysql-database-to-mssql-using-phpmyadmin/
This documentation seems pretty conclusive - http://www.waynezim.com/2010/03/how-to-export-mysql-database-to-mssql-using-phpmyadmin/