blocks|key|1787238|text|尽管我不确定是否有好的方法将模式从一个DB自动复制到另一个数据库(也许这就是您的问题)，但是使用您自己的PHP解决方案肯定是可行的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1787239|如果您只是复制数据，并且/或者您需要自定义代码在两个DB之间转换修改过的模式，我建议您使用PDO和5.2%2B库。您将能够使用PDO+ODBC+(并使用MSSQL驱动程序)进行连接。在使用其他库将MSSQL中的大型文本字段和多字节字符导入PHP时，我遇到了很多问题。|1787240|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Rolling your own PHP solution will certainly work though I'm not sure if there is a good way to automatically duplicate the schema from one DB to the other (maybe this was your question).

If you are just copying data, and/or you need custom code anyway to convert between modified schemas between the two DB's, I would recommend using PHP 5.2+ and the PDO libraries. You'll be able to connect using PDO ODBC (and use MSSQL drivers). I had a lot of problems getting large text fields and multi-byte characters from MSSQL into PHP using other libraries.

blocks|key|1572335|text|另一个可以尝试的工具是SQLMaestro+suite。确定精确的工具有点棘手，但他们有各种各样的工具，既有免费的，也有可购买的，可以为多个数据库平台处理各种各样的任务。我建议先尝试MySQL的数据向导工具，因为我相信它会有您需要的适当的“导入”工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1572336|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlmaestro.com/^0|B|G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Another tool to try would be the <a href="http://www.sqlmaestro.com" rel="nofollow noreferrer">SQLMaestro suite</a>. It is a little tricky nailing down the precise tool, but they have a variety of tools, both free and for purchase that handle a wide variety of tasks for multiple database platforms. I'd suggest trying the Data Wizard tool first for MySQL, since I believe that will have the proper &quot;import&quot; tool you need.

blocks|key|1787334|text|我找到的最好的方法是MySQL提供的MySQL+Migration+Toolkit。我已经在一些大型迁移项目中成功地使用了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1787335|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mysql.com/products/tools/migration-toolkit/^0|I|N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The best way that I have found is the <a href="http://www.mysql.com/products/tools/migration-toolkit/" rel="noreferrer">MySQL Migration Toolkit</a> provided by MySQL. I have used it successfully for some large migration projects.

blocks|key|1787377|text|SQL+Server2005的“标准版”、“开发版”和“企业版”都有SSIS，它取代了SQL+server2000中的DTS。SSIS有一个到它自己的DB的内置连接，您可以找到其他人为MySQL编写的连接。Here就是一个例子。一旦有了连接，您就应该能够创建一个SSIS包来在两者之间移动数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1787378|我不需要将数据从SQLServer移动到MySQL，但我想一旦安装了MySQL连接，它的工作方式就像在两个SQLServer数据库之间移动数据一样，这非常简单。|1787379|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQL_Server_Integration_Services|1|http://jmayo.spaces.live.com/blog/cns!5F243997972597CE!399.entry^0|Y|4|0|2V|4|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

SQL Server 2005 &quot;Standard&quot;, &quot;Developer&quot; and &quot;Enterprise&quot; editions have <a href="http://en.wikipedia.org/wiki/SQL_Server_Integration_Services" rel="nofollow noreferrer">SSIS</a>, which replaced DTS from SQL server 2000. SSIS has a built-in connection to its own DB, and you can find a connection that someone else has written for MySQL. <a href="http://jmayo.spaces.live.com/blog/cns!5F243997972597CE!399.entry" rel="nofollow noreferrer">Here</a> is one example. Once you have your connections, you should be able to create an SSIS package that moves data between the two.
I ddin't have to move data from SQLServer to MySQL, but I imagine that once the MySQL connection is installed, it works the same as moving data between two SQLServer DBs, which is pretty straight forward.

blocks|key|1572444|text|使用MSSQL+Management+Studio，我已经将表与MySQL+OLE+DB进行了转换。右键单击您的数据库并转到“任务->导出数据”，从那里您可以指定一个MsSQL+OLE+DB源，MySQL+OLE+DB源，并创建两个数据源之间的列映射。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1572445|您很可能希望在MySQL目标上预先设置数据库和表(导出希望自动创建表，但这通常会导致失败)。通过右键单击数据库，可以使用"Tasks->Generate+Scripts“在MySQL中快速创建表。一旦生成了创建脚本，您将需要单步执行并搜索/替换MSSQL到MYSQL中存在的关键字和类型。|1572446|当然，您也可以像正常一样备份数据库，并找到一个实用程序来恢复MYSQL上的MSSQL备份。然而，我不确定是否存在一个。|1572447|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Using MSSQL Management Studio i've transitioned tables with the MySQL OLE DB. Right click on your database and go to "Tasks->Export Data" from there you can specify a MsSQL OLE DB source, the MySQL OLE DB source and create the column mappings between the two data sources. 

You'll most likely want to setup the database and tables in advance on the MySQL destination (the export will want to create the tables automatically, but this often results in failure). You can quickly create the tables in MySQL using the "Tasks->Generate Scripts" by right clicking on the database. Once your creation scripts are generated you'll need to step through and search/replace for keywords and types that exist in MSSQL to MYSQL. 

Of course you could also backup the database like normal and find a utility which will restore the MSSQL backup on MYSQL. I'm not sure if one exists however.

I've been banging my head against <code>SQL Server 2005</code> trying to get a lot of data out. I've been given a database with nearly 300 tables in it and I need to turn this into a MySQL database. My first call was to use bcp but unfortunately it doesn't produce valid CSV - strings aren't encapsulated, so you can't deal with any row that has a string with a comma in it (or whatever you use as a delimiter) and I would still have to hand write all of the create table statements, as obviously CSV doesn't tell you anything about the data types.

What would be better is if there was some tool that could connect to both SQL Server and MySQL, then do a copy. You lose views, stored procedures, trigger, etc, but it isn't hard to copy a table that only uses base types from one DB to another... is it?

Does anybody know of such a tool? I don't mind how many assumptions it makes or what simplifications occur, as long as it supports integer, float, datetime and string. I have to do a lot of pruning, normalising, etc. anyway so I don't care about keeping keys, relationships or anything like that, but I need the initial set of data in fast!

How to export data from SQL Server 2005 to MySQL

备份数据库

SQL数据库

SQL Server

数据库

MySQL

我一直在和SQL Server 2005拼命工作，试图获取大量的数据。我得到了一个包含近300个表的数据库，我需要将其转换为MySQL数据库。我的第一个调用是使用bcp，但不幸的是它不能产生有效的CSV -字符串没有封装，所以你不能处理任何带有逗号的字符串(或者任何你用来作为分隔符的东西)，我仍然需要手工编写所有的cr...

问如何将数据从SQL Server2005导出到MySQL
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将数据从SQL Server2005导出到MySQLEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将数据从SQL Server2005导出到MySQL
EN