Re: SQL Server to Oracle DB
All this coding stuff is fine if there is a one-to-one correlation between the SQL Server tables and the Oracle tables. If not, then the first thing that needs to be accomplished is mapping the SQL Server tables to Oracle. This can be a fun job especially if data is required in Oracle that doesn't exist in the old tables. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 2:13 PM > The code to do this in Perl is trivial, and you get the bonus of complete > control, > as well as the ability to generate sqlloader control and paramters files > on the fly. > > Jared Still > Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) > > > > > > > "Tim Gorman" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/20/2002 10:43 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: 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. 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 - > To: Multiple recipients of list ORACLE-L > Sent: Monday, May 20, 2002 9:08 AM > > 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 - > To: Multiple recipients of list ORACLE-L > Sent: Monday, May 20, 2002 9:03 AM > > 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. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Server to Oracle DB
The code to do this in Perl is trivial, and you get the bonus of complete
control,
as well as the ability to generate sqlloader control and paramters files
on the fly.
Jared Still
Oracle DBA and Part Time Perl Evangelist ( feels like full time lately )
"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2002 10:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: 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. 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 -
To: Multiple recipients of list ORACLE-L
Sent: Monday, May 20, 2002 9:08 AM
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 -
To: Multiple recipients of list ORACLE-L
Sent: Monday, May 20, 2002 9:03 AM
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL Server to Oracle DB
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.
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.
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB Use the SQLServer DTS package. Under the SQLServer program menu, choose the import/export option, and it will start a Data Transformation Service wizard type thing for you. You can also do SQL transformations and alike as well, by opening the SQL Server Enterprise Manager console, expanding the server that you would like to export the data from, and under the Data Transformations folder, right click on Local Packages and create a new one.. All sorts of options in there, and probably best to hit whilst on the screen.. HTHMark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard HuntleySent: 20 May 2002 15:03To: Multiple recipients of list ORACLE-LSubject: 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.
RE: SQL Server to Oracle DB
Title: Message If your Oracle platform is Windows, take a look at Heterogeneous Services. I just tried it Friday for the first time to load data from an Excel spreadsheet and it seems to work pretty well. Should work for SQL Server. HTH, Beth -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB You can use BCP Utility (SQL Server side), to download SQL SERVER data into a flat file (text file) and then you can use SQLLOADER (Oracle Side). I hope it may helps you Best Regards Kamel Benlatreche -Message d'origine-De : Richard Huntley [mailto:[EMAIL PROTECTED]]Envoyé : lundi 20 mai 2002 14:03À : Multiple recipients of list ORACLE-LObjet : 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.
Re: SQL Server to Oracle DB
Title: 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.
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB I would use SQL Servers DTS tool. It is relatively easy depending on how much data you have to move. I use it fasirly often to move data between Oracle, SQL Server, DB2 and other data sources. Dave -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 9:03 AMTo: Multiple recipients of list ORACLE-LSubject: 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.
sql server to oracle db
Rich, since you have SQL SERVER, do you have DTS?, thats the easiest way to move he data around. joe
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB Use BCP to export data from SQL Server and SQL Load import data into Oracle DB. Brian Chen -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: 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.
SQL Server to Oracle DB
Title: 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.
