Last post Apr 30, 2013 04:46 PM by JavierVera
Apr 30, 2013 04:46 PM|JavierVera|LINK
Hello people in forum and web surfers, i am here to ask you some interesting stuff wich is pretty much related with the migration from SQL Server to Oracle 10, 11g.
So far i've googled several people asking why methods get conflict or app crash when trying to use stored procedures and so on.
I'd like you to advice me some considerations to make this for example:
-> duplicate production base stored procedures and tables so we could re-script them(or generate them) to run it on Oracle
-> recreate indexes and run them into oracle etc etc.
What other advices could you tell in order to achieve this migration in the cleanest possible way?
I am preparing some brainstorming with my group where this should be the main purpose.
Also, i am pretty sure there are several people who faced such situations in the past, for those guys and girls: what were your most difficult task to achive?, how did you manage to sort it? did you talk to a boss in order to get permissons? etc etc.
Thanks in advance and i hope we could also start sharing some management ideas and so on.