Richard:
Yes. The way I've done it in the past is to generate
tilde (~) delimited flat files and then load the data into Oracle via
SQL*Loader. You have to do a mapping first before using SQL*Loader. Then
you have to write scripts for each table you are loading. I recommend the
O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process
that can take time especially if the Oracle application needs data that the old
legacy DB doesn't provide.
My $0.02 worth,
Ken Janusz, CPIM
|
Title: SQL Server to Oracle DB
- SQL Server to Oracle DB Richard Huntley
- RE: SQL Server to Oracle DB Chen, Brian
- sql server to oracle db JOE TESTA
- RE: SQL Server to Oracle DB Farnsworth, Dave
- RE: SQL Server to Oracle DB KENNETH JANUSZ
- RE: SQL Server to Oracle DB GL2Z/ INF DBA BENLATRECHE
- RE: SQL Server to Oracle DB Seefelt, Beth
- RE: SQL Server to Oracle DB Mark Leith
- Re: SQL Server to Oracle DB Tim Gorman
- Re: SQL Server to Oracle DB Jared . Still
- Re: SQL Server to Oracle DB KENNETH JANUSZ