Oracle to SQL Server stored procedure & function converter

Do you know of a tool that converts开发者_C百科 Oracle user defined functions to SQL Server? I used swiss sql online converter but it converts some of my functions.

The Microsoft SQL Server Migration Assistant for Oracle should be able to convert certain PL/SQL functions to SQL Server.

However, since PL/SQL is so much more powerful than T-SQL, every tool will fail at a certain point.

I can see trying to do this being problematic because you are changing from PL/SQL to T/SQL; they are different languages.

There are some some functions and operators that exist in one and not the other. Depending on what you are using in the sprocs, you may have to do a workaround or a rewrite of significant parts.

Take a look at some of these

Microsoft T-SQL to Oracle PL/SQL translation

oracle_sql_server_differences_equivalents

Reference sqlserver