如何将SQL Server数据库迁移到MySQL? [英] How to migrate SQL Server database to MySQL?

问题描述

我有一个包含大量数据的 SQL Server 数据库和一个空的 MySQL 数据库.现在，我想将SQL Server数据库的所有数据(包括数据库架构)复制到MySQL数据库.

I have a SQL Server database with lots of data and an empty MySQL database. Now I want to copy all data of SQL Server database (including the database schema) to the MySQL database.

我曾考虑过使用原始SQL转储，但是SQL Server的SQL语法与MySQL不同.

I thought about using raw SQL dump, but SQL Server's SQL syntax is not same as MySQL.

我已经用Google搜索了一些数据库迁移工具，例如 south (仅适用于django)， simple-db-migration (仅适用于一种类型的数据库，也许是PostreSQL ?)和 SQLAlchemy (我还没有完成学习，只是觉得它有些笨拙).

And I have googled some database migration tool, such as south (only for django), simple-db-migration (only for one type of database, maybe PostreSQL?) and SQLAlchemy (I haven't finished learning it, just feeling it somewhat clunky).

我可以使用什么工具进行此迁移?

What tool can I use to do this migration?

推荐答案

我通常将 opendbcopy 用于此类工作. ..

I'm usually using opendbcopy for these kind of jobs ...

这篇关于如何将SQL Server数据库迁移到MySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！