Oracle to SqlServer Code conversion

ashe

New member
Hey any JATt echies..


could u please help with any link or free tool for converting Oracle..to sqlserver code
iam trying migrate Oracle PL/sql to tsql.. i tried with Swisssql.. but its not that good.. any other tool please refer.. im in need of it..


Thanks in Advance,,:cool:
 
i tried it.. i was previously.. using Swisssql...

But the thing is face problems..


yeah i have googled too.. reenu... (thanks :) )
but tried if at all any one can suggest something better..
 
Hi ashe,

Please write the error code,Description and Snapshot(if any).

Regards,
S. Jaglan

i tried it.. i was previously.. using Swisssql...

But the thing is face problems..


yeah i have googled too.. reenu... (thanks :) )
but tried if at all any one can suggest something better..
 
there is no equivalent for somethings like packages,spool command etc.. this.. gives a problem i have to individually break it..



and i happened to read it somewhere.. that its difficult to find some tool.. to really move the code most of the parts has to manually converted..

nOW THE PROB IS HOW DO I ADDRESS THE "PACKAGES"



BTW thanks for all u r spontaneous replies.
 
Last edited:
Well, not very sure from where you read it, tool is not available. One year back, I have migrated SQLServer code into postgres code using tools, and it was very easy to do. I found it through google only.
I dont have that link right now, will try to find it and will post you.
Meanwhile you can also search for tools. This is the only easy option for migration.

there is no equivalent for somethings like packages,spool command etc.. this.. gives a problem i have to individually break it..



and i happened to read it somewhere.. that its difficult to find some tool.. to really move the code most of the parts has to manually converted..

nOW THE PROB IS HOW DO I ADDRESS THE "PACKAGES"



BTW thanks for all u r spontaneous replies.
 
This is where i read it.,... and its difficult to find equivalents..:redface:


http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm



Well, not very sure from where you read it, tool is not available. One year back, I have migrated SQLServer code into postgres code using tools, and it was very easy to do. I found it through google only.
I dont have that link right now, will try to find it and will post you.
Meanwhile you can also search for tools. This is the only easy option for migration.
 
Thanks..


i have to do this in current sprint.. and i have posted them on various forums and blogs.. and everyone suggests for manual coding...


I will try to find it today if possible...will post you if get it.
 
Manual coding will take lot of time to do it. But meanwhile you can start coding it as you dont have any other option available in your hand for current time. I used that tool in my previous company so dont have any link with me right now. I will ask my ex-colleauge if they could have saved it.


Thanks..


i have to do this in current sprint.. and i have posted them on various forums and blogs.. and everyone suggests for manual coding...


[/COLOR]
 
The link you have posted here shows that you are getting null pointer exception i.e. null(there is some object which is getting null value). First resolve null pointer exception to perform this.
Or you can give me your package code so I can try here at my side to resolve this.

Hey Hi renu

http://search.swissql.com/oratosql/jsp/Evaluation.jsp


This link is working for simple pl/sql... but still i have prob in replacing Packages...
for now im trying to move that package to a procedure..
but facing problems with INTTAB and NUMTAB.. functions are converted...



Regards
ASHE
 
Back
Top