Migration from MS SQL Server to Oracle?

0 like 0 dislike
8 views
Please advise software to database migration from MS SQL Server 2005 to Oracle 11. Yes, I know on good it is necessary to rewrite all handles, but as available nemeryannom hranimyh procedures in T-SQL, consisting of continuous bydlokod and little time interested in the possibility of fast migration automatically, without regard to performance degradation, etc.


Interested in the possibility of migration of the entire database — tables, data, functions, procedures, views, etc.


Tried Oracle SQL developer is he good, but he was not able to transmit part of the stored procedures. Apparently, if nothing are new, will have ostanovitsa on this option and rewrite the rest of the procedure manually.


Another tried SQLWAYS, but it is in many procedures change the signature to return settings on the sly, that is not an option. Besides, he had something not happened with the re-establishment of some sequence's.


Maybe someone has faced a similar problem and finally found good software for this purpose?
by | 8 views

4 Answers

0 like 0 dislike
I need it to I think fear is not loss of productivity, and loss of functionality, data emigrirovat I think not difficult, but the stored procedure put a programmer to rewrite.
by
0 like 0 dislike
by
0 like 0 dislike
The table data at least through the export-import Excel to overtake. But with functions and procedures - have to sweat. All Pl/SQL and T-SQL are different things.

As a medium I recommend PL/SQL Developer: www.allroundautomations.com/plsqldev.html
Still many people like TOAD: www.quest.com/toad-dba-suite-for-oracle
And there are people who use both products (everyone knows how much of their hityk).

By the way, there's TOAD for MS SQL Server: www.quest.com/toad-for-sql-server
by
0 like 0 dislike
Can this list to add dbForge Studio for Oracle: https://www.devart.com/ru/dbforge/oracle/studio/
Also have for SQL Server: https://www.devart.com/ru/dbforge/sql/studio/
by

Related questions

0 like 0 dislike
4 answers
0 like 0 dislike
2 answers
asked Apr 21, 2019 by nicenice
0 like 0 dislike
2 answers
0 like 0 dislike
3 answers
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
28,804 users