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 ?
我有大约200 GB的Mysql转储文件,现在我需要迁移到Sql server 2008.那么我应该遵循什么方法,我应该继续逐行sql语句还是有任何适合我要求的GUI工具?
1 个解决方案
#1
5
Microsoft SQL Server Migration Assistant for MySQL v1.0
用于MySQL v1.0的Microsoft SQL Server迁移助手
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.
Microsoft SQL Server迁移助手(SSMA)是一个工具包,可以显着降低从MySQL迁移到SQL Server 2005,SQL Server 2008,SQL Server 2008 R2和SQL Azure的工作量,成本和风险。
#1
5
Microsoft SQL Server Migration Assistant for MySQL v1.0
用于MySQL v1.0的Microsoft SQL Server迁移助手
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.
Microsoft SQL Server迁移助手(SSMA)是一个工具包,可以显着降低从MySQL迁移到SQL Server 2005,SQL Server 2008,SQL Server 2008 R2和SQL Azure的工作量,成本和风险。