Results 1 to 5 of 5

Thread: SQL Server Migration

  1. #1
    Join Date
    Feb 2005
    Posts
    6

    SQL Server Migration

    I want to migrate from a SQL server 2000 database to Oracle 10g. What is the asiest way to do it, as time is a constraint. If I use DTS then does it migrate the stored procs as well, or do I have to change them manually?

    Thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    DTS does not migrate stored procedures to Oracle. You have to change them manually or use some commerically avaiable tools.

  4. #4
    Join Date
    Mar 2005
    Location
    Germany
    Posts
    10
    I've tried SwisSQL. This tool also converts stored procs and functions:

    http://www.swissql.com/products/sqls...to-oracle.html

    regards,

    Helmut Leitner

  5. #5
    Join Date
    Feb 2005
    Posts
    6

    SwisSql

    Thanks all. I have downloaded SwisSql and trying it now.

Posting Permissions

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