MySQL到PostgreSQL [英] mySQL to postgreSQL

问题描述

我们正在尝试将我们的应用程序从与mySQL的对话转换为postgres。我希望我们可以有某种子例程（在VB6中），只要我可以输入mySQl SQL查询并获取包含适当的postgres查询的字符串即可。

We are trying to switch our application from talking to mySQL to postgres. I wished we would have some kind of a subroutine (in VB6) were I can input the mySQl SQL query and get a string out containing the appropriate postgres query.

有人吗？有解决方案或有兴趣与我们合作？

Does anybody have a solution or is interested working with us on that?

推荐答案

我会咨询不同SQL实现的比较； 当将查询从一个RDBMS转换到另一个RDBMS时，它是最有用的参考。 WikiBooks上还有一个标题为>将MySQL转换为PostgreSQL的页面。

I would consult the "Comparison of Different SQL Implementations;" it's a most useful reference when converting queries from one RDBMS to another. WikiBooks also has a page entitled "Converting MySQL to PostgreSQL." It has a short list of the big differences between the two.

我不知道有任何（免费/开源）实用程序来翻译查询，但是除非您有非常大而复杂的查询，否则您不会翻译它们应该不会有太大的困难（而且，如果您有大型而复杂的查询，那么自动化工具可能会无济于事）。

I don't know of any (free/open source) utility to translate queries, but unless you have really big, complicated queries, you shouldn't have much difficulty translating them (and, if you do have big, complicated queries, an automated tool probably won't help).

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