Re: Import into SQL Server Oracle Database from Export File (SQL*Loader)

From: oj (nospam_ojngo_at_home.com)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 00:24:05 -0800

Clever! ;-) 

-- 
-oj
"Norm Powroz" <npowroz.delete.this.part@and.this.part.rogers.com> wrote in 
message news:1a45v09n8p0j4ud4ep57cdu91vgav6qv2r@4ax.com...
> On Fri, 21 Jan 2005 14:42:22 -0000, "K Kelly" <kkelly@nospam.com> wrote:
>
>>I need to import an Oracle Database into SQL Server 2000.
>>
>>I know this can be done easily using DTS but I do not have access to the
>>Oracle Database, I only have an Oracle Database Export File.
>>
>>The Export file has been generated using SQL*Loader.
>>
>
> While it may not be strictly legal from a licensing standpoint, there is 
> an approach that may work. First, Oracle
> makes copies of their older software available for downloading from their 
> website. Therefore, you could download a
> copy of Oracle and install it on a suitable system. Next, import the 
> Oracle database from the export file. Be
> warned -- the export file also includes information on directory locations 
> for database files, rollback segments,
> and so on. In order for the import to work properly, you need to make sure 
> that you replicate the file system
> environment exactly. Oracle will not re-create it on the fly, so you may 
> spend quite a bit of time reading error
> logs before you can get it right. In the end, though, it should work 
> correctly.
>
> Once you have the Oracle database up and running, use DTS from SQL Server 
> to cross over the data you need,
> remembering to deal with issues such as data type conversions, etc. 
> (pardon me for straying into "I know that!!"
> areas). After you get it crossed over, then kill the Oracle installation 
> before the license police catch you.
>
> I once did a similar thing years ago in the opposite direction. I needed 
> to move a DocsOpen SQL 4.0 database into
> Oracle 7.2, but the Docs application no longer supported SQL 4, only SQL 
> 6.5 and above. However, Microsoft had a
> 120-day demonstration version of SQL 6.5 on their website. So I downloaded 
> that, used it to upgrade the SQL 4
> database to SQL 6.5, then ran DocsOpen to move it from SQL Server to 
> Oracle 7.2. Worked a treat. Crazily enough, I
> have to now move that same database from Oracle 8.1 to SQL Server 2000 in 
> the next couple of weeks.
>
> Good luck.
>

Relevant Pages

  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 vs Oracle
    ... SQL and Oracle. ... SQL Server one sizes log files to handle the largest transaction and its ...
    (comp.databases.ms-sqlserver)
  • Re: IOT, memory and transaction time
    ... What is a better way of structuring this SQL for Oracle? ... Oracle expertise available at the moment but certainly SQL Server ... Server uses dynamic memory allocation whereas Oracle, in our tests, ...
    (comp.databases.oracle.misc)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: SQL -> Oracle
    ... > 2- extracted all my SQL queries in one single file (that was the tedious ... > 3- now whenever I need new query. ... > - Sybase and SQL server prefix their parameters with '@' ... > - Firebird and Oracle have selectable stored procedures so you use them ...
    (borland.public.delphi.non-technical)