从MySql迁移到Sql server 2008

本文介绍了从MySql迁移到Sql server 2008的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有Mysql转储文件大约200 GB，现在我需要迁移到Sql服务器2008.所以我应该遵循的方法，我应该继续行的sql语句或有任何GUI工具可用，适合我的要求？

I have Mysql dump file of around 200 GB, now I need to migrate into Sql server 2008. So What approach I should follow, should I go ahead with the line by line sql statement or is there any GUI tool available which suits to my requirement ?

推荐答案

Microsoft SQL Server Migration Assistant for MySQL v1.0

Microsoft SQL Server迁移 Assistant（SSMA）是一个工具包，大大降低了工作量，成本，和从MySQL迁移到$ b的风险$ b SQL Server 2005，SQL Server 2008，SQL Server 2008 R2和SQL Azure。

Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.