Re: Migrating from MS SQL Server to Oracle

From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/07/14
Message-ID: <01bc909e$abd61da0$096fc589@RSNOWDEN.labinterlink.com>#1/1

Create scripts to crank each table out to a sequential file, perhaps comma-delimited. You can use the Bulk copy facility of SQL Server. Then, use Oracles sqlloader utility to plug the tables into Oracle. Sqlloader is fast and reliable. Not difficult to learn. Also, quite flexible. So, simplify the output process and focus on the sqlloader tool.

Note: build the empty tables without referential integrity constraints or indexes. Load the tables flat, then build indexes and constraints after the fact. Use the exception clause for foreign key constraints to track down the bad rows. Get it loaded, then fix-up later.

Roger Snowden

> Is there any simple method of migrating all the data in an MS SQL Server
> to an Oracle V7 Database Server?
Received on Mon Jul 14 1997 - 00:00:00 CDT