DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Porting from MS SQL Server to Oracle

  1. 05-17-2003, 02:08 AM #1
    apar_6
    apar_6 is offline Junior Member
    Join Date
    May 2003
    Location
    Chennai, India
    Posts
    5

    Porting from MS SQL Server to Oracle

    Hi,
    Need help on porting code from MS SQL Server to Oracle. Could u please advice on the requisites for porting ? In our case, SQL Server has stored procedures also. Will there be any extra effort required to port stored procs ? I have not worked on SQL Server. Can the codes written in SQL Server be re-used as is or is any alteration needed ? I would like to know about how constraints are dealt with.

    Regards,
    Aparna S.
    Reply With Quote Reply With Quote
  2. 05-18-2003, 06:35 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268

    Re: Porting from MS SQL Server to Oracle

    Hi,
    You can use Oracle's Migration toolkits.
    They work great.

    http://otn.oracle.com/software/tech/...h/content.html

    Cheers,
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width