将T-SQL转换为MySQL [英] Convert T-SQL to MySQL

问题描述

是否有一种简单的方法可以将 Transact-SQL 转换为MySQL?

Is there an easy way to convert Transact-SQL to MySQL?

我正在尝试转换股票代码和公司名称的数据库档案.

I am attempting to convert a database archive of stock ticker symbols and company names.

推荐答案

简短答案:否

中等答案: MAYBE

长答案:这取决于您的TSQL中的内容以及要投入多少时间和精力.

TSQL不是MySQL的方言子集.因此，存在一些没有MySQL转换的TSQL.但是，两种语言之间的重叠非常重要，并且在某种程度上转换只是语法问题.

TSQL is not a subset of MySQL's dialect. So there exists some TSQL for which there is no MySQL conversion. However, the overlap between the two languages is pretty significant, and to a certain degree the conversion is just a matter of syntax.

这不是一个新问题，有些人已尝试解决它.在Google上快速搜索"将tsql转换为mysql 即可一些有希望的结果，特别是这里的这个项目，它试图将存储过程从TSQL转换为MySQL:

This isn't a new problem, and some people have tried to tackle it. A quick google search for "tsql to mysql" yields some promising results, notably this project here, which attempts to convert stored procedures from TSQL to MySQL:

http://sourceforge.net/projects/tsql2mysql/

这可能无法完全解决您的问题，但这至少是一个开始.

This probably won't solve your problem completely, but it's at least a start.

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