Re: SQL Server to Oracle DB

[Tim Gorman]

Title: SQL Server to Oracle DB

...speaking of $0.02, make sure that the utility from SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics.  I was recently burned on a Sybase->Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal.  Since SQL Server comes from Sybase, beware...   In ISQL, I could just divide everything by 1.0000 to get the true precision, but BCP doesn't provide that option.  Instead, I wrote a shell script to query the Sybase data dictionary to generate the "C" program sources for each table.  The Sybase APIs were perfectly capable of handling numeric precision, but the %&^&#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly.  Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent...   Just FYI... ----- Original Message ----- From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Subject: Re: SQL Server to Oracle DB 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 ----- Original Message ----- From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Subject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.