Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    Unanswered: How can I import data from MSSQL2000 into Oracle 8.1.7?

    Sorry for possible dummy question, but I have to import data (tables only)
    from MSSQL2000 to my Oracle 8.1.7. I would like to know how is this done
    and what tools (Oracle native is preffered) can I use ? DTS Wizard from
    MSSQL distribution cant correctly create tables on Oracle.

  2. #2
    Join Date
    Nov 2002

    Re: How can I import data from MSSQL2000 into Oracle 8.1.7?

    Have you tried Oracle Migration Workbench ? It is freely downloadable and you get plugins for the different databases like access,sql server etc.
    Check it out at

  3. #3
    Join Date
    Apr 2002
    California, USA


    Check a migration tool called Chyfo.

    This is a migration tool that can easy migrate MS SQL Server database into Oracle and IBM DB2. It migrates tables, indexes, constraints, defaults. It supports moving of LOBs (text, image) as well.

    For more details go to their web site.

    Hope that helps,

    OCP - DBA

Posting Permissions

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