Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: Oracle .dmp To SQL Server 2000

    Hi guys,
    I am a SQL Server 2000 DBA and was given a task to get an Oracle .dmp file into SQL Server.
    Is it even possible to do? Or do I have to script the Oracle DB and import the DB that way?
    But then how would I get the data?

    I need to get the Oracle structure and the Data over to SQL Server.

    PLease help.

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: Oracle .dmp To SQL Server 2000

    Why not run the DTS application that comes with SQL-Server?

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Well, as of right now I don't have access to the Oracle. I only have the .dmp file.

  4. #4
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208
    The only suggestion I have, and its ugly is to install a local copy of Oracle, import the file, and then use DTS to migrate to Sql-Server.

    The DMP file is binary, and in a format that Oracle Import uses. I don't know if you can modify the file into a format that is readable by DTS.

    HIH

    Good Luck

  5. #5
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    OK, thanks

  6. #6
    Join Date
    Apr 2004
    Posts
    2

    Unhappy

    i very much doubt you'll be able to get sql server to accept oracle .dmp input. rather, use amended select statements to create csv data spooled to file. sql server, like db2's load utility and oracle's sql*loader has a utility to handle this.

    alternatively, for seamless migration use oracle's gateway product to allow the databases to talk directly to each other.

    of course, this is all useless to you if you can't get at the database

Posting Permissions

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