如何将mySql SQL脚本转换为MS SQL one? [英] How do I convert mySql SQL script to MS SQL one?

问题描述

我必须将客户MySql数据库架构/数据迁移到MS SQL SERVER2008.最后，我收到了带有与Microsoft SQL不兼容的mySQL方言的70 Mb SQL文件.

I have to migrate customer MySql database schema/data to MS SQL SERVER 2008. Finally I've received 70 Mb SQL file with mySQL dialect that is incompatible with MSSQL.

DROP TABLE IF EXISTS `kladr`;
CREATE TABLE `kladr` (
  `id` int(11) NOT NULL DEFAULT '0',
  `idp` int(11) DEFAULT NULL,
...

花了一个星期的谈判才能收到这样的文件，所以我怕让mySQL管理员向我发送与MS SQL SERVER兼容的sql.有没有一种方法可以将mySQL方言自动转换为MSSQL SERVER方言?

It took a week of negotiations to receive such a file so I'm afraid to ask mySQL administrators to send me MS SQL SERVER compatible sql. Is there a way to convert mySQL dialect to MSSQL SERVER dialect automatically ?

推荐答案

SQLines提供工具和服务来帮助您传输数据，转换数据库架构(DDL)，视图，存储过程和函数，触发器，查询，嵌入式SQL语句和从MySQL到Microsoft SQL Server的SQL脚本.

SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MySQL to Microsoft SQL Server.

http://www.sqlines.com/online

这篇关于如何将mySql SQL脚本转换为MS SQL one?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！