blocks|key|1774639|text|我得到的印象是，大多数答案都集中在迁移整个数据库上，或者只是指出T-SQL和PL/SQL之间的一些差异。我最近也遇到了同样的问题。Oracle数据库已经存在，但我需要将大量的T-SQL脚本转换为PL/SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1774640|我安装了Oracle+SQL+Developer并运行了Translation+Scratch+Editor+(工具>迁移>临时编辑器)。|offset|length|1774641|然后，只需输入您的T-SQL，在下拉列表中选择正确的转换(应该默认为'T-SQL+to+PL/SQL')，然后转换它。|1774642|entityMap|0|LINK|mutability|MUTABLE|url|https://www.oracle.com/tools/downloads/sqldev-downloads.html|1|http://www.oracle.com/technetwork/database/migration/scratchlauncher-098387.html^0|0|4|K|0|S|Q|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]|$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

I get the impression most answers focus on migrating an entire database or just point to some differences between T-SQL and PL/SQL. I recently had the same problem. The Oracle database exists, but I need to convert a whole load of T-SQL scripts to PL/SQL.
I installed <a href="https://www.oracle.com/tools/downloads/sqldev-downloads.html" rel="nofollow noreferrer">Oracle SQL Developer</a> and ran the <a href="http://www.oracle.com/technetwork/database/migration/scratchlauncher-098387.html" rel="nofollow noreferrer">Translation Scratch Editor</a> (Tools &gt; Migration &gt; Scratch Editor).
Then, just enter your T-SQL, choose the correct translation in the dropdown-list (it should default to 'T-SQL to PL/SQL'), and convert it.

blocks|key|1559286|text|我不得不提一些事情。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1559287|1)当我在Oracle8上工作时，你不能做"Select+@Result"，你必须使用虚拟表，如下所示"Select+@Result+from+dual“。不确定这种荒谬是否仍然存在。|1559288|2)在Oracle的世界里，他们似乎很喜欢游标，你最好仔细阅读一下，他们一直在使用游标。|1559289|祝你好运，祝你愉快，|1559290|它与MS+SQL没有太大的不同。谢天谢地，我不再需要使用它了，我又回到了MS工具的温暖舒适中。|1559291|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I have to things to mention.

1) When I worked on Oracle 8, you could not do "Select @Result", you had to instead use the dummy table as follows "Select @Result from dual". Not sure if that ridiculousness still exists.

2) In the Oracle world they seem to love cursors and you better read up on them, they use them all the time AFAICS.

Good luck and enjoy,

it is not that different to MS SQL. Thankfully, I do not have to work with it anymore and I am back in the warm comfort of MS tools.

blocks|key|1559080|text|如果您将ISNULL和NVL废话替换为COALESCE，它将在T-SQL和PL/SQL中工作！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1559081|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you replace your ISNULL and NVL nonsense with COALESCE, it'll work in T-SQL and PL/SQL!

blocks|key|1774225|text|来回映射它们并不是微不足道的，所以我怀疑有没有工具可以自动完成这项工作。但是这个链接可能会对你有所帮助：http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1774226|entityMap|0|LINK|mutability|MUTABLE|url|http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm^0|1G|1Y|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

It's not trivial to map them back and forth, so I doubt there's a tool that does it automatically. But this link might help you out: <a href="http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm" rel="nofollow noreferrer">http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm</a>

blocks|key|1774453|text|我已经完成了一些从SQL+server到oracle的迁移。如果不重写后端代码，就无法进行迁移。两个数据库之间的差异太多了，更重要的是程序员的两种思维方式之间的差异。许多经理认为这两个是可以互换的，我有经理让我从SQL+server复制存储过程并在oracle中编译它们，一点线索都没有！Toad是目前市场上支持oracle应用程序的最佳工具。SQL+developer还可以，但与toad相比就令人失望了。我希望oracle有一天能赶上他们的产品，但它还没有做到。祝您愉快:)如果您要迁移到oracle，这是有原因的，为了满足这个要求，您需要重写后端代码，否则会有很多问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1774454|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have done a few SQL server to oracle migrations. There is no way to migrate without rewriting the backend code. Too many differences between the 2 databases and more importantly differences between the 2 mind sets of the programmers. Many managers think that the 2 are interchangeable, I have had managers ask me to copy the stored procedures from SQL server and compile them in oracle, not a clue! Toad is by far the best tool on the market for supporting an oracle application. SQL developer is ok but was disappointing compared to toad. I hope that oracle will catch their product up to toad one day but it is not there yet. Have a good day :) chances are if you are migrating to oracle it is for a reason and in order to meet that requirement you will need to rewrite the back end code or you will have many issues.

blocks|key|1774575|text|在Oracle+SQL+Developer中，有一个名为翻译暂存编辑器的工具。您可以在Tools+>+Migration中找到它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1774576|Oracle+SQL+Developer可以从Oracle免费下载，而且安装起来也很容易。|1774577|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In Oracle SQL Developer, there is a tool called Translation Scratch Editor. You can find it from Tools > Migration.

The Oracle SQL Developer is a free download from Oracle and it is an easy install.

blocks|key|1774336|text|如果您正在进行一次性转换，而不是尝试支持两个版本，则必须考虑Oracle+Migration+Workbench。该工具可以与Oracle的SQLDeveloper一起使用(如果您正在使用Oracle，那么您实际上应该使用它)。这将执行模式、数据和一些T-SQL到PL/SQL的转换。我对两者都很了解，我发现它做了大约80%25的工作。它足够好到值得转换大部分过程，并手动转换剩余的“更难”的未知部分。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1774337|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/tech/migration/workbench/index_sqldev_omwb.html^0|U|Q|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you're doing a one-off conversion, rather than trying to support two versions, you must look at <a href="http://www.oracle.com/technology/tech/migration/workbench/index_sqldev_omwb.html" rel="nofollow noreferrer">Oracle Migration Workbench</a>. This tool works with Oracle's SQLDeveloper (which you really should have if you are working with Oracle). This does a conversion of the schema, data, and some of the T-SQL to PL/SQL. Knowing both well, I found it did about an 80% job. Good enough to make it worth while to convert the bulk of procedures, and hand convert the remainder "tougher" unknown parts.

blocks|key|1774375|text|价格不便宜(995美元)，但这个工具效果很好：http://www.swissql.com/products/sql-translator/sql-converter.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1774376|entityMap|0|LINK|mutability|MUTABLE|url|http://www.swissql.com/products/sql-translator/sql-converter.html^0|N|1T|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Not cheap ($995) but this tool works great: <a href="http://www.swissql.com/products/sql-translator/sql-converter.html" rel="nofollow noreferrer">http://www.swissql.com/products/sql-translator/sql-converter.html</a>

blocks|key|1774537|text|有几个人在这里提到了来回转换。我不知道有什么工具可以从MSSQL转换到Oracle，但我使用免费的MS工具将Oracle数据库转换为MSSQL，它对我有效，并且转换了一个大型数据库，没有任何问题，我可以调用。它类似于微软免费提供的访问MSSQL工具。尽情享受|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1774538|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

A few people have mentioned here converting back and forward. I do not know of a tool to convert from MSSQL to Oracle, but I used the free MS tool to convert a Oracle db to MSSQL and it worked for me and converted a large db with no problems I can call. It is similar to the Access to MSSQL tool that MS also provide for free. Enjoy

blocks|key|1559480|text|jOOQ有一个公开可用的免费翻译器，可以从以下网站访问：https://www.jooq.org/translate|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1559481|它支持DML、DDL和一些过程性语法元素。如果您希望通过命令行在本地运行转换，可以购买许可证，命令行的工作方式如下：|1559482|$+java+-cp+jooq-3.11.9.jar+org.jooq.ParserCLI+-t+ORACLE+-s+"SELECT+substring('abcde',+2,+3)"
select+substr('abcde',+2,+3)+from+dual;|code-block|syntax|javascript|1559483|请参阅：https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-cli|1559484|(免责声明，我为供应商工作)|1559485|entityMap|0|LINK|mutability|MUTABLE|url|https://www.jooq.org/translate|1|https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-cli^0|S|U|0|0|0|0|4|25|1|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|13|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]]]

jOOQ has a publicly available, free translator, which can be accessed from the website here: <a href="https://www.jooq.org/translate" rel="nofollow noreferrer">https://www.jooq.org/translate</a>

It supports DML, DDL, and a few procedural syntax elements. If you want to run the translation locally via command line, a license can be purchased and the command line works as follows:

<pre class="lang-none prettyprint-override"><code>$ java -cp jooq-3.11.9.jar org.jooq.ParserCLI -t ORACLE -s "SELECT substring('abcde', 2, 3)"
select substr('abcde', 2, 3) from dual;
</code></pre>

See: <a href="https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-cli" rel="nofollow noreferrer">https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-cli</a>

(Disclaimer, I work for the vendor)

I've worked with T-SQL for years but I've just moved to an organisation that is going to require writing some Oracle stuff, probably just simple CRUD operations at least until I find my feet. I'm not going to be migrating databases from one to the other simply interacting with existing Oracle databases from an Application Development perspective. Is there are tool or utility available to easily translate T-SQL into Oracle SQL, a keyword mapper is the sort of thing I'm looking for.

P.S. I'm too lazy to RTFM, besides it's not going to be a big part of my role so I just want something to get me up to speed a little faster.

Microsoft T-SQL to Oracle SQL translation

Oracle数据库

数据库

我已经使用T-SQL多年了，但我刚刚转到一个需要编写一些Oracle内容的组织，可能只是简单的CRUD操作，至少在我找到自己的脚之前是这样。从应用程序开发的角度来看，我不会简单地将数据库从一个数据库迁移到另一个数据库，与现有Oracle数据库交互。有没有工具或实用程序可以轻松地将T-SQL转换为Oracle SQL，关键字映射器就是我正在寻找的那类东西。另外，我对RTFM太懒了，而且它不会是我角色

问Microsoft T-SQL到Oracle SQL的转换
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft T-SQL到Oracle SQL的转换EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft T-SQL到Oracle SQL的转换
EN