Page 1 of 2 1 2 LastLast
Results 1 to 20 of 32

Thread: Oracle to SqlServer Code conversion

  1. #1

    Lightbulb Oracle to SqlServer Code conversion

    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,,
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  2. The Following User Says Thank You to ashe For This Useful Post:

    sukhbirhooda (February 22nd, 2012)

  3. #2
    Hi Ashe,

    Warm Regards,

    As per your Query

    you can use SwissSql tools.

    or check
    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108579

    if still you find its not Productive.

    Please let me know,will assign/refer someone who can help you out.

    Regards,
    S. Jaglan
    I find brothers in all castes , love in all religions. This whole world is my family .

  4. The Following User Says Thank You to saurabhjaglan For This Useful Post:

    sukhbirhooda (February 22nd, 2012)

  5. #3
    There are lot of free tools available for migration from one DB to another. One can google out easily to find it.
    Some links are here for the same : -

    http://www.swissql.com/

    http://www.swissql.com/products/orac...ql-server.html

    http://www.microsoft.com/sqlserver/e...ol.aspx#oracle

  6. #4
    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..
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  7. #5
    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..
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  8. #6
    Hi ashe,

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

    Regards,
    S. Jaglan

    Quote Originally Posted by ashe View Post
    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..
    I find brothers in all castes , love in all religions. This whole world is my family .

  9. #7
    Try this one..These links will provide you free trial of conversion tools :-

    http://www.swissql.com/products/orac...ldownload.html

    http://www.spectralcore.com/fullconv...-to-oracle.php


    Quote Originally Posted by ashe View Post
    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..

  10. #8
    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 by ashe; February 21st, 2012 at 04:05 PM. Reason: MISSEED SOME INFO
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  11. #9
    and i have found something like we can write our functions codes in .net and we can use them in sqlserver 2005 and above...

    http://stackoverflow.com/questions/2...pl-sql-package

    I'am new to Sqlserver... how do we do that...??
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  12. #10
    Hi ashe,

    Post you queries in http://www.orafaq.com/forum/f/1/0/

    Try this,Hope This one could be helpful to you.

    Regards,
    S. Jaglan
    I find brothers in all castes , love in all religions. This whole world is my family .

  13. #11
    Post you queries in http://www.orafaq.com/forum/f/1/0/

    Try this,Hope This one could be helpful to you.

    thanks.. for this link Saurabh


    and renu this helps in migrating objects only tables from oracle to sqlserver... along with its data.. i have tried its trial..
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  14. #12
    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.

    Quote Originally Posted by ashe View Post
    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.

  15. #13
    This is where i read it.,... and its difficult to find equivalents..


    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.
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  16. #14
    I will try to find it today if possible...will post you if get it.

    Quote Originally Posted by ashe View Post
    This is where i read it.,... and its difficult to find equivalents..


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



    [/COLOR]

  17. #15
    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.
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  18. #16
    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.


    Quote Originally Posted by ashe View Post
    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]

  19. The Following User Says Thank You to reenu For This Useful Post:

    saurabhjaglan (February 22nd, 2012)

  20. #17
    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
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  21. #18
    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.

    Quote Originally Posted by ashe View Post
    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

  22. #19
    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
    The biggest adventure u can take is to live life of your dreams..
    Bidiyasar a!!!!!

  23. #20
    I know that. I have already seen this.. I am asking for your code(what actual problem you are getting) so I can check with it to solve.

    Quote Originally Posted by ashe View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •