Migrating from MS SQL Server to Oracle?

Question

Oracle

Please advise software for migrating a database from MS SQL Server 2005 to Oracle 11. Yes, I know that in a good way it would be necessary to rewrite everything by hand, but since there are a lot of stored procedures in T-SQL consisting of a continuous bydlocode and little time is of interest the ability to quickly migrate in automatic mode, without regard to performance degradation, etc.
Interested in the possibility of migrating the entire database - tables, data, functions, procedures, views, etc.
I tried Oracle SQL developer - he is good, but he could not translate part of the stored procedures. Apparently, if nothing new is found, we will have to stop at this option and rewrite the remaining procedures manually.
I also tried SQLWAYS, but in many procedures it changes the signature for returning parameters in a tricky way, which is not an option. In addition, something did not work out for him with the reconstruction of some sequences.
Maybe someone faced a similar task and found a good software for these purposes?

Answer 1

Here it is necessary, in my opinion, to be afraid not of a decrease in performance, but of the loss of part of the functionality, I think it’s not difficult to migrate data, but many stored procedures can be rewritten by a programmer.

Answer 2

try here www.oracle.com/technetwork/database/migration/sqlserver-095136.html

Answer 3

Data tables can be overtaken even through Excel export-import. But with the functions and procedures - you have to sweat. Yet Pl/SQL and T-SQL are different things.
I recommend PL/SQL Developer as an environment: www.allroundautomations.com/plsqldev.html
A lot of people like TOAD: www.quest.com/toad-dba-suite-for-oracle
And there are people who use both products (each can do a lot of their githiks).
By the way, TOAD is also available for MS SQL Server: www.quest.com/toad-for-sql-server

Answer 4

I can add dbForge Studio for Oracle to this list: https://www.devart.com/ru/dbforge/oracle/studio/
Also available for SQL Server: https://www.devart.com/ru/dbforge/sql /studio/