Re: How to Replicate from SQL Server 2000 to Oracle 9i
From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 08 Jan 2003 08:00:15 -0800
Message-ID: <3E1C4B0F.E53C9DF2_at_exesolutions.com>
Date: Wed, 08 Jan 2003 08:00:15 -0800
Message-ID: <3E1C4B0F.E53C9DF2_at_exesolutions.com>
piter197 wrote:
> one time and data only.
>
> --
> Posted via http://dbforums.com
Dump the data as delimited or fixed length and load into Oracle using SQL*Loader.
To generate identical table structures reverse engineer the DDL using Visio or ERWin or some other tool if you don't have a build script to execute.
Remember, VERY IMPORTANT, that the concepts and architecture behind Oracle are VERY different from those of SQL Server so some mental process should take place (and don't use CHAR fields in Oracle, use VARCHAR2, for strings).
Daniel Morgan Received on Wed Jan 08 2003 - 17:00:15 CET