Migration from Oracle 7.34 to SQL 2000

  • I'm attempting to move a database which currently exists on an old Oracle 7.34 instance and tried to use Data Import via DTS to SQL 2000.

    The Oracle database consists of views, indexes,packages,triggers as well as tables structures.  I tried DTS using both the ODBC and OLE for Oracle and only tables and data came over correctly.

    Views it appears were converted into tables.

    I'm using the Oracle 9.2 client on my workstation.

    Any ideas on how I might be able to convert this database over from Oracle?

     

    thks

     

  • Packages do no exist in SQL Server, you will need to convert these into stored procedures and/or User defined functions. Any stored procedures, triggers or functions will also need to be re-written to use TSQL instead of PL/SQL.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply