将数据从Microsoft SQL（.MDF）文件导入MySQL [英] Import data from Microsoft SQL (.MDF) file into MySQL

问题描述

我在我的Windows Vista中运行 PHP / 5.3.0 与 Apache / 2.2.17（Win32） PC。我有MySQL服务器版本：5.5.8。我有一个包含一些表的Database.MDF文件。我想将这些数据导入我的MySQL数据库。我安装了Microsoft SQL Server。我使用PHP MyAdmin。任何人都有解决方案或软件包？

I am running PHP/5.3.0 with Apache/2.2.17 (Win32) in my Windows Vista PC. I have MySQL server version: 5.5.8. I have a Database.MDF file containing some tables. I want to import this data into my MySQL database. I have Microsoft SQL Server installed. I use PHP MyAdmin. Anybody got a solution or a software package?

推荐答案

如果你没有安装MSSQL最简单的选择是安装< a href =http://www.microsoft.com/sqlserver/en/us/editions/express.aspx =nofollow> SQL Server Express ，附加您的mdf，然后从那里导出。您有很多选项，从最简单的csv导出/导入，使用工具，如 OpenDbCopy ，或写作自定义代码连接到数据库和从一个加载到另一个。

If you don't have MSSQL installed the simplest option would be to install SQL Server Express, attach your mdf, then export from there. You have quite a few options, from the simplest csv export/import, using a tool such as OpenDbCopy, or writing custom code to connect to both database and load from one to the other.

这篇关于将数据从Microsoft SQL（.MDF）文件导入MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！