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..
http://search.swissql.com/oratosql/jsp/Evaluation.jsp
i tried this.. i felt this is easier but it could do small things query conversion not for Larger source codes.. Procedures... etc etc..
Post you queries in http://www.orafaq.com/forum/f/1/0/
Try this,Hope This one could be helpful to you.
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.
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.
This is where i read it.,... and its difficult to find equivalents..:redface:
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
[/COLOR]
I will try to find it today if possible...will post you if get 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]
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
No ya.. u have to go in with ur mail id
http://search.swissql.com/oratosql/index.html
try this...
and login by any email id
We use essential cookies to make this site work, and optional cookies to enhance your experience.