469,167 Members | 1,150 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

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
Jul 20 '05 #1
4 8382
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" <cc******@hotmail.com> wrote in message
news:22**************************@posting.google.c om...
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

Jul 20 '05 #2
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" <cc******@hotmail.com> wrote in message
news:22**************************@posting.google.c om...
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

Jul 20 '05 #3
"John Bell" <jb************@hotmail.com> wrote in message news:<41***********************@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" <cc******@hotmail.com> wrote in message
news:22**************************@posting.google.c om...
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
Jul 20 '05 #4
cc******@hotmail.com (ccc31807) wrote in message news:<22**************************@posting.google. 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.
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ralph Noble | last post: by
1 post views Thread by David Berry | last post: by
4 posts views Thread by BostonNole | last post: by
1 post views Thread by Chicagoboy27 | last post: by
1 post views Thread by Eric | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.