import dmp into SQL Server

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ccc31807

    #1

    import dmp into SQL Server

    A newby question:

    I've got a .dmp from from an Oracle database that I need to import
    into SQL Server. I have no idea how to do this.

    If anyone know how to do this, I'd very, very much appreciate the
    help.

    Thanks, CC
  • Big Time

    #2
    Re: import dmp into SQL Server

    Data Transformation Services should be able to handle this just fine. You
    can find it in Entreprise Manager. The wizard should walk you through all
    the steps.



    "ccc31807" <ccc31807@hotma il.comwrote in message
    news:22e055d5.0 408270728.66a49 87c@posting.goo gle.com...
    A newby question:
    >
    I've got a .dmp from from an Oracle database that I need to import
    into SQL Server. I have no idea how to do this.
    >
    If anyone know how to do this, I'd very, very much appreciate the
    help.
    >
    Thanks, CC

    Comment

    • John Bell

      #3
      Re: import dmp into SQL Server

      Hi

      Output files exported from Oracle using the Oracle Export utility may
      contain DDL as well as data, it will also probably contain multiple tables
      and other objects. If this is your situation then I suggest that you install
      Oracle onto a machine and then either create a linked server or export it in
      a different way.

      John
      "ccc31807" <ccc31807@hotma il.comwrote in message
      news:22e055d5.0 408270728.66a49 87c@posting.goo gle.com...
      A newby question:
      >
      I've got a .dmp from from an Oracle database that I need to import
      into SQL Server. I have no idea how to do this.
      >
      If anyone know how to do this, I'd very, very much appreciate the
      help.
      >
      Thanks, CC

      Comment

      • John Miller

        #4
        Re: import dmp into SQL Server

        "John Bell" <jbellnewsposts @hotmail.comwro te in message news:<41304103$ 0$25950$afc38c8 7@news.easynet. co.uk>...
        Hi
        >
        Output files exported from Oracle using the Oracle Export utility may
        contain DDL as well as data, it will also probably contain multiple tables
        and other objects. If this is your situation then I suggest that you install
        Oracle onto a machine and then either create a linked server or export it in
        a different way.
        >
        John
        "ccc31807" <ccc31807@hotma il.comwrote in message
        news:22e055d5.0 408270728.66a49 87c@posting.goo gle.com...
        A newby question:

        I've got a .dmp from from an Oracle database that I need to import
        into SQL Server. I have no idea how to do this.

        If anyone know how to do this, I'd very, very much appreciate the
        help.

        Thanks, CC

        You may want use third party tool like FastReader form WisdomForce
        (www.wisdomforce.com) to unload Oracle tables into ascii text file.
        FastReader also generates input for mssql loader. One quick step
        process

        Comment

        • cr_announce

          #5
          Re: import dmp into SQL Server

          ccc31807@hotmai l.com (ccc31807) wrote in message news:<22e055d5. 0408270728.66a4 987c@posting.go ogle.com>...
          A newby question:
          >
          I've got a .dmp from from an Oracle database that I need to import
          into SQL Server. I have no idea how to do this.
          >
          If anyone know how to do this, I'd very, very much appreciate the
          help.
          >
          Thanks, CC
          You may want to use a 3rd-party tool such as CampaignRunner for this.
          You can then will port data from Oracle directly to SQL Server,
          bypassing the file-based mechanisms, in just a few mouse clicks.

          Comment

          Working...