如何将数据从 SQL Server 2005 导出到 MySQL

How to export data from SQL Server 2005 to MySQL(如何将数据从 SQL Server 2005 导出到 MySQL)

问题描述

我一直在反对 SQL Server 2005 试图获取大量数据.我得到了一个包含近 300 个表的数据库，我需要将其转换为 MySQL 数据库.我的第一个调用是使用 bcp 但不幸的是它不会产生有效的 CSV - 字符串没有被封装，所以你不能处理任何包含逗号的字符串的行(或任何你用作分隔符的行)而且我仍然需要手写所有的创建表语句，因为显然 CSV 不会告诉您有关数据类型的任何信息.

I've been banging my head against SQL Server 2005 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.

如果有一些工具可以连接到 SQL Server 和 MySQL，那就更好了，然后复制一份.您丢失了视图、存储过程、触发器等，但将仅使用基本类型的表从一个数据库复制到另一个数据库并不难......是吗?

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!

推荐答案

我发现的最好方法是 MySQL 迁移工具包 由 MySQL 提供.我已经成功地将它用于一些大型迁移项目.

The best way that I have found is the MySQL Migration Toolkit provided by MySQL. I have used it successfully for some large migration projects.

这篇关于如何将数据从 SQL Server 2005 导出到 MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！