Re: Importing oracle database into sql server 2000
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/24/04
- Next message: ran melnik: "can not save in DTS get EXCEPTION_ACCESS_VIOLATION"
- Previous message: AS: "Importing oracle database into sql server 2000"
- In reply to: AS: "Importing oracle database into sql server 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 11:53:21 -0700
The .dmp is the default extension for Oracle's export
utility. You wouldn't want to use Oracle's export utility
for migrating data to another database platform. The utility
creates a proprietary file format that's used with Oracle's
import utility.
You can import the data in Oracle using DTS by connecting to
the Oracle instance and importing the data into a SQL Server
database. There is often a bit more to the migration than
just moving data. You may want to review the following
Chapter from the SQL Server Resource Kit:
Chapter 7 - Migrating Oracle Databases to SQL Server 2000
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
-Sue
On Wed, 24 Mar 2004 12:26:12 -0500, "AS" <azs007@yahoo.com>
wrote:
>Hi,
>We have an Oracle database and we'd like to migrate to Sql server 2000. I
>have exported all the data from the oracle db into a .dmp file... Is it
>possible to use this to import into sql server.. If not, how do I go about
>doing this..
>
>Thanks,
>Regards,
- Next message: ran melnik: "can not save in DTS get EXCEPTION_ACCESS_VIOLATION"
- Previous message: AS: "Importing oracle database into sql server 2000"
- In reply to: AS: "Importing oracle database into sql server 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
