Geek Answers Handbook

Migration tool from TSQL to PL / SQL?

We need to transfer our database from MSSQL to Oracle, and we have more than 100 stored procedures written in TSQL PL / SQL . I know his long shot, but has anyone ever successfully used an automatic migration tool to do this job? I have seen some tools on the Internet, but I cannot judge their ability to process various codes. Any personal experience in this matter will help.

+5
source share
3 answers

, . , .

№ 1

:

Spectral Core Full Convert Enterprise

?

, . SQL Server SSIS.

№ 2

, Oracle , .

Oracle: Microsoft SQL Server Oracle

:

SQL Developer Migration Microsoft SQL Server:

  • Oracle.
  • , Oracle.
  • , , T-SQL Oracle PL/SQL.
  • , , .
  • .
  • DDL Oracle.

  • , .

    • , , ;
    • , ;
    • .

, SQL Server Oracle, , . , 3. Convert SQL Server T-SQL to Oracle PL/SQL (syntax and equivalences) .

+4

. -, 100 . , - getutcdate() current_timestamp .. , , , , . / PL/SQL, , , , / .

!

+5

In the past, I tried to do the opposite, but I'm afraid that there is no 100% reliable way. Some features are unique to each RDBMS and cannot be replicated by the tool (for example, the IDENTITY fields in SQL Server vs Sequences in Oracle). Given that in the end I had to review each stored procedure to make sure that it was doing what it was supposed to do, I realized that it was better to plan a manual port and learn PL / SQL during its execution.

+1
source

More articles:


All Articles