Results 1 to 12 of 12
  1. #1
    Join Date
    Sep 2003
    Posts
    66

    Unhappy Unanswered: How to covert Oracle Store Procedure to SQLServer

    Is there any easy to do this, covert Oracle store procedure to SQL Server 2000.
    Any help is thankful.
    --iqueen.

  2. #2
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59
    try using the oracle stored procedure directly in oracle.
    I hope it will execute.
    Again it depends on what version of oracle u have.

    I have used sql SP on oracle with minor changes
    Cyrus
    Finding ways for solution

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by cyrus
    I have used sql SP on oracle with minor changes
    I doubt it...

    Why not post some code to show us though....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Sep 2003
    Posts
    66
    the problem is : I have change my Database Server, Oracle->SQLServer2000, the data have transfer to SQL Server, easy done with DTS, but Store Procedure won't, what shall I do ,wanna enable the same store procedure in SQL Server.
    Any help is thankful.
    --iqueen.

  5. #5
    Join Date
    Sep 2003
    Posts
    66
    There is really a lot of store procedure , more than 2000.

  6. #6
    Join Date
    Oct 2003
    Location
    Pune, India
    Posts
    14
    I do not have ORACLE here however I think it can be done using DTS.

    After you select the Target Source and Destination Source, you are provided with 3 options one of which says "Copy Objects and..."

    If you opt for this option, you get options for all types of objects.

    Please let me know if that does not work. Thanks.
    Thanks & Regards,
    Dipayan Sarkar
    (dipayan@covisible.com)
    (CoVisible Solutions - A Knowledge Management Software company)

  7. #7
    Join Date
    Sep 2003
    Posts
    66
    DTS can NOT transfer the store procedure....
    Originally posted by tampu
    I do not have ORACLE here however I think it can be done using DTS.

    After you select the Target Source and Destination Source, you are provided with 3 options one of which says "Copy Objects and..."

    If you opt for this option, you get options for all types of objects.

    Please let me know if that does not work. Thanks.

  8. #8
    Join Date
    Oct 2003
    Posts
    3
    Oracle uses PL-SQL and SQL Server uses T-SQL.. . . .although they are much similar as regards ANSI standards but syntactical differences are definitely there. .. . .. ..functions... . processes and other things sre different
    you can refer to microsoft site for they provide much info as to shift orcale code to SQL Server ... ..

  9. #9
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59
    see if this attachment helps u
    Attached Files Attached Files
    Cyrus
    Finding ways for solution

  10. #10
    Join Date
    Dec 2001
    Location
    India
    Posts
    25
    the attachment contains basics of oracle Architecture
    it will not help for Oracle to Sql 2k conversion.

    Regards,
    Selva Balaji B.

  11. #11
    Join Date
    Oct 2003
    Location
    Pune
    Posts
    59
    Sorry ,Probably I gave a wrong one
    There no concrete help but difference between oracle and sql
    see if it helps u
    Attached Files Attached Files
    Cyrus
    Finding ways for solution

  12. #12
    Join Date
    Dec 2001
    Location
    India
    Posts
    25
    Hi cyrus

    This is an useful document.

    Regards,
    Selva Balaji B.

Posting Permissions

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