>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 we
bsite. 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 f
or database files, rollback segments,
and so on. In order for the import to work properly, you need to make sure t
hat you replicate the file system
environment exactly. Oracle will not re-create it on the fly, so you may spe
nd quite a bit of time reading error
logs before you can get it right. In the end, though, it should work correct
ly.
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 bef
ore 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 t
hat, 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 th
e next couple of w
s.Good luck.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:
>
> 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 w
s.> Good luck.
>
No comments:
Post a Comment