How to migrate Oracle DB to SQL Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to migrate Oracle DB to SQL Server

  1. #1
    Join Date
    Feb 2003
    Posts
    22

    Question How to migrate Oracle DB to SQL Server

    Hi,

    i need to migrate a oracle database to sql server.

    Only tables, procedure, indices no data.

    Is there any roundup available?

    I know its kind a hard to ask such a question in an oracle forum

    Hopefully waiting for a solution.

    Greetz
    Eldrik

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    Lightbulb

    1) Export the schema:

    exp uid/pw owner=MySchema rows=N file=MySchema.txt

    2) Get DBATool (free from http://www.databee.com )

    3) Generate an SQL script file and edit (modify) to SQL Server specs.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Feb 2003
    Posts
    22
    thx that tool helped me out

  4. #4
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    I think you can set up a database link from to the Oracle database and just pull everything across with DTS.

  5. #5
    Join Date
    Feb 2003
    Posts
    22
    i also used DTS but i managed only the tables and there data to sqlserver.

    Objects like indices, procedures, constraints are not copied by DTS.

    But with DBATOOL vom DATAbee its much easier to get the indices and constraints.

Posting Permissions

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



Click Here to Expand Forum to Full Width