Tool to translate statement selects, update,etc From Sqlserver to Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tool to translate statement selects, update,etc From Sqlserver to Oracle

  1. #1
    Join Date
    Jan 2002
    Posts
    22
    Know a Tool to translate statement selects, update,etc From Sqlserver to Oracle?

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    AFAIK there is not such thing, but even if so, SURELY I vote against the use . See, some CRUCIAL differences arise between SQL server and Oracle, for example : in SQL Server we HAVE to lock records before readings, in Oracle NOT, and so on, and on and on .....
    So, if you translate directly this, you will end with a VERY BAD Oracle app, running like a horse with 3 broken legs.
    Therefore I recommend : bite the bullet, learn Oracle SQL and donīt translate, RECODE in the right way, to use the (many) good features of Oracle.

    Regards,

    Chiappa

  3. #3
    Join Date
    Jan 2002
    Posts
    33
    to add to JChiappa's thread, you can post your sql server query and i am sure there are folks in this forum, including me who can help you translate the code initially till you learn it.

Posting Permissions

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


Click Here to Expand Forum to Full Width