1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to import Stored Procedure from SQL Server to oracle

Discussion in 'Server Administration and Options' started by asifbhura, Mar 21, 2009.

  1. asifbhura

    asifbhura Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello,

    I am using SQL Server2005 & Oracle10g

    OS: Windows XP

    I have some SP(stored procedure) in SQL SERVER,

    I want to import these SP to my Oracle DB

    how can i import SP to oracle.

    Regards,
    ASIF
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    hi asif, to migrate from sql server to oracle you can either use the old oracle migration workbench or download and install oracle sql developer which incorporates migration support functionality offered by the original Oracle Migration Workbench.

    However if it's just a few procedures it would be easier to just do it by hand...
     
  3. asifbhura

    asifbhura Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    hi tyro

    can u show me example

    Regards,
    ASIF
     
  4. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
  5. alhanani

    alhanani Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    what do you want exactly ..?
    import the continnence or what if yes you can used data upload program or by SQL loader