将MS SQL脚本转换为Mysql和Oracle [英] Convert MS SQL script to Mysql and Oracle

问题描述

我开发的应用程序之一已在客户站点本地安装.这意味着我们必须支持MySQL，MSSQL和Oracle，因为并非所有客户都使用同一数据库引擎.

One of the applications I develop gets installed locally on the customer's site. This means that we have to support MySQL, MSSQL and Oracle as not all the customers use the same database engine.

我正在为应用程序编写一个补丁，其中一部分涉及执行5000行的sql脚本以对数据库进行修改.该脚本是使用MSSQL语法编写的，但是我想知道是否有一个应用程序可以将MSSQL语法自动转换为Oracle和/或MySQL的语法，从而使我不必手动执行操作.

I'm writing a patch for the application, part of which involves executing a 5000 line sql script to make modifications to the database. The script is written using MSSQL syntax, however I was wondering if there is an application for automatically converting MSSQL syntax to that of Oracle and/or MySQL to save me from having to manually do it.

推荐答案

这是一个古老的话题，但是我建议使用以下工具: http://www.sqlines.com/online .我有很好的使用经验.自3个月前(我开始使用它)以来，没有发现任何问题.

This is an old topic, but i would recommend using the following tool: http://www.sqlines.com/online. I had a good experience using it. No problems found since 3 months ago (when i've started using it).

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