Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: Tools for Convert Oracle .dmp to MsSQL Server

    Hello everyone.
    Could you tell me please, any tools for converting oracle .dmp to MsSQL server without need Oracle or access direct to Oracle server, just from .dmp to sql server. Thx

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    You are aware that you posted in the PostgreSQL forum?
    Which has absolutely nothing to do with either Oracle or SQL Server.

    Btw: the only tools that can read a binary Oracle dump file are the Oracle tools impdb and the deprecated imp. Both need a running Oracle instance to work properly.

    So the answer to your question is a clear: no, there is no such tool.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Apr 2013
    Posts
    9
    This is a PostgreSQL forum =)

    The most correct but not always the easiest way is to write a migration tool (in Java for ex.).

    And the most primitive way would be to make a plain sql dump from the source database, and adapt it to the target db using massive replacement by patterns (Notepad++ would do nicely). Though this applies only to a basic table/view structure. As soon as you hit the BLOBS or database specific objects (triggers, sequences, etc.) it becomes hell.

Tags for this Thread

Posting Permissions

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