blocks|key|1279513|text|我在网上找到了一种方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1279514|它需要一些工作，因为它必须逐个表格地完成。但不管怎样，我可以将表、数据和约束复制到MS+SQL数据库中。|1279515|这是链接|1279516|http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx|offset|length|1279517|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|1U|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@$H|U|I|V|1|W]]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|G]]]]

I found a way for this on the net

It demands a little bit of work, because it has to be done table by table. But anyway, I could copy the tables, data and constraints into a MS SQL database.

Here is the link

<a href="http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx" rel="noreferrer">http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx</a>

blocks|key|1279578|text|使用SQL+Server+Migration+Assistant+(SSMA)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1279579|除了MySQL之外，它还支持Oracle、Sybase和MS+Access。|1279580|它看起来相当智能，甚至能够处理非平凡的传输。它还提供了一些命令行界面(除了GUI)，因此理论上它可以集成到一些批处理加载过程中。|1279581|这是MySQL版本https://www.microsoft.com/en-us/download/details.aspx?id=54257的当前下载链接|1279582|当前(2016年6月)稳定版本6.0.1在传输数据时与当前(5.3.6)+MySQL+ODBC驱动程序崩溃。都是64位的。带有5.1.13+ODBC驱动程序的5.3版工作正常。|1279583|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017|1|https://www.microsoft.com/en-us/download/details.aspx?id=54257^0|2|11|0|0|0|0|9|1Q|1|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]]]

Use <a href="https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017" rel="noreferrer">SQL Server Migration Assistant (SSMA)</a> 

In addition to MySQL it supports Oracle, Sybase and MS Access.

It appears to be quite smart and capable of handling even nontrivial transfers. It also got some command line interface (in addition to GUI) so theoretically it can be integrated into some batch load process.

This the current download link for MySQL version <a href="https://www.microsoft.com/en-us/download/details.aspx?id=54257" rel="noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=54257</a>

The current (June 2016) stable version 6.0.1 crashes with the current (5.3.6) MySQL ODBC driver while transferring data. Everything 64 bit. 
The 5.3 version with the 5.1.13 ODBC driver works fine.

blocks|key|1279466|text|如果您使用PhpMyAdmin进行导出，则可以将sql兼容模式切换为“MSSQL”。这样，您只需对MS+SQL数据库运行导出的脚本，就完成了。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1279467|如果你不能或不想使用PhpMyAdmin，在mysqldump中也有一个兼容性选项，但就我个人而言，我更愿意让PhpMyAdmin为我做这件事。|1279468|entityMap|0|LINK|mutability|MUTABLE|url|http://www.phpmyadmin.net/|1|http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html^0|5|A|0|0|M|9|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|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]]]]

If you do an export with <a href="http://www.phpmyadmin.net/" rel="noreferrer">PhpMyAdmin</a>, you can switch sql compatibility mode to 'MSSQL'. That way you just run the exported script against your MS SQL database and you're done.

If you cannot or don't want to use PhpMyAdmin, there's also a compatibility option in <a href="http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html" rel="noreferrer">mysqldump</a>, but personally I'd rather have PhpMyAdmin do it for me.

blocks|key|1279744|text|对我来说，最好使用以下命令导出所有数据：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1279745|mysqldump+-u+USERNAME+-p+--all-databases+--complete-insert+--extended-insert=FALSE+--compatible=mssql+>+backup.sql|code-block|syntax|javascript|1279746|--extended-insert=FALSE是为了避免mssql+1000行的导入限制。|1279747|我是用迁移工具创建表的，所以我不确定从backup.sql文件创建是否有效。|1279748|在MSSQL的SSMS中，我必须在IDENTITY_INSERT打开的情况下逐表导入数据表，以写入ID字段：|1279749|SET+IDENTITY_INSERT+dbo.app_warehouse+ON;
GO+
INSERT+INTO+"app_warehouse"+("id",+"Name",+"Standort",+"Laenge",+"Breite",+"Notiz")+VALUES+(1,'01','Bremen',250,120,'');
SET+IDENTITY_INSERT+dbo.app_warehouse+OFF;
GO+|1279750|如果您有关系，则必须先导入子对象，然后再导入具有外键的表。|1279751|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

For me it worked best to export all data with this command:

<pre><code>mysqldump -u USERNAME -p --all-databases --complete-insert --extended-insert=FALSE --compatible=mssql &gt; backup.sql
</code></pre>

--extended-insert=FALSE is needed to avoid mssql 1000 rows import limit.

I created my tables with my migration tool, so I'm not sure if the CREATE from the backup.sql file will work.

In MSSQL's SSMS I had to imported the data table by table with the IDENTITY_INSERT ON to write the ID fields:

<pre><code>SET IDENTITY_INSERT dbo.app_warehouse ON;
GO 
INSERT INTO "app_warehouse" ("id", "Name", "Standort", "Laenge", "Breite", "Notiz") VALUES (1,'01','Bremen',250,120,'');
SET IDENTITY_INSERT dbo.app_warehouse OFF;
GO 
</code></pre>

If you have relationships you have to import the child first and than the table with the foreign key.

blocks|key|1279677|text|您也可以使用'ODBC‘%2B+'SQL+Server导入和导出向导’。下面的链接描述了它：https://www.mssqltips.com/sqlservertutorial/2205/mysql-to-sql-server-data-migration/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1279678|​|1279679|📷|atomic|1279680|1279681|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mssqltips.com/sqlservertutorial/2205/mysql-to-sql-server-data-migration/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/032ea97f04a52421c2d3d94bb1870e3a.jpeg|imageAlt^0|18|2C|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|I|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]|R|$5|S|N|T|C|$U|V|W|-4]]]]

Also you can use 'ODBC' + 'SQL Server Import and Export Wizard'.
Below link describes it:
<a href="https://www.mssqltips.com/sqlservertutorial/2205/mysql-to-sql-server-data-migration/" rel="nofollow noreferrer">https://www.mssqltips.com/sqlservertutorial/2205/mysql-to-sql-server-data-migration/</a>

<a href="https://i.stack.imgur.com/GRV6F.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GRV6F.jpg" alt="enter image description here"></a>

blocks|key|1064972|text|运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1064973|mysqldump+-u+root+-p+your_target_DB+--compatible=mssql+>+MSSQL_Compatible_Data.sql|code-block|syntax|javascript|1064974|是否要查看进程栏？|1064975|pv+mysqldump+-u+root+-p+your_target_DB+--compatible=mssql+>+MSSQL_Compatible_Data.sql|1064976|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Run:

<pre><code>mysqldump -u root -p your_target_DB --compatible=mssql &gt; MSSQL_Compatible_Data.sql
</code></pre>

Do you want to see a process bar? 

<pre><code>pv mysqldump -u root -p your_target_DB --compatible=mssql &gt; MSSQL_Compatible_Data.sql
</code></pre>

blocks|key|1279847|text|您可以使用sqlie应用程序从mysql转换为sqlserver您可以观看此视频https://www.youtube.com/watch?v=iTVEqys_vTQ&t=108s|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1279848|entityMap|0|LINK|mutability|MUTABLE|url|https://www.youtube.com/watch?v=iTVEqys_vTQ&t=108s^0|14|1E|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]]]]

you can use sqlie application for converting from mysql to sqlserver
you can watch this video
<a href="https://www.youtube.com/watch?v=iTVEqys_vTQ&amp;t=108s" rel="nofollow noreferrer">https://www.youtube.com/watch?v=iTVEqys_vTQ&amp;t=108s</a>

I have a .sql file from a MySQL dump containing tables, definitions and data to be inserted in these tables. How can I convert this database represented in the dump file to a MS SQL Server database?

Import MySQL database into a MS SQL Server

SQL数据库

SQL Server

数据库

MySQL

我有一个来自MySQL转储的.sql文件，其中包含要插入到这些表中的表、定义和数据。如何将转储文件中表示的此数据库转换为MS SQL Server数据库？

问将MySQL数据库导入MS SQL Server
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将MySQL数据库导入MS SQL ServerEN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将MySQL数据库导入MS SQL Server
EN