FAQ
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: Richard Huntley
INET: rhuntley_at_mindleaders.com

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: ListGuru_at_fatcity.com (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).

Search Discussions

  • Farnsworth, Dave at May 20, 2002 at 2:53 pm
    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-----
    Sent: Monday, May 20, 2002 9:03 AM
    To: Multiple recipients of list ORACLE-L

    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: Farnsworth, Dave
    INET: DFarnsworth_at_Ashleyfurniture.com

    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: ListGuru_at_fatcity.com (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).
  • KENNETH JANUSZ at May 20, 2002 at 3:08 pm
    SQL Server to Oracle DBRichard:

    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.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: KENNETH JANUSZ
    INET: kjanusz_at_att.net

    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: ListGuru_at_fatcity.com (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).
  • GL2Z/ INF DBA BENLATRECHE at May 20, 2002 at 3:08 pm
    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
    Envoyé : lundi 20 mai 2002 14:03
    À : Multiple recipients of list ORACLE-L
    Objet : 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.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: GL2Z/ INF DBA BENLATRECHE
    INET: kbenlatreche_at_lth.sonatrach.dz

    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: ListGuru_at_fatcity.com (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).
  • Chen, Brian at May 20, 2002 at 3:13 pm
    Use BCP to export data from SQL Server and SQL Load import data into Oracle
    DB.


    Brian Chen

    -----Original Message-----
    Sent: Monday, May 20, 2002 10:03 AM
    To: Multiple recipients of list ORACLE-L

    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: Chen, Brian
    INET: Brian.Chen_at_Bowne.com

    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: ListGuru_at_fatcity.com (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).
  • JOE TESTA at May 20, 2002 at 3:23 pm
    Rich, since you have SQL SERVER, do you have DTS?, thats the easiest way to move he data around.

    joe

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: JOE TESTA
    INET: JTESTA_at_longaberger.com

    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: ListGuru_at_fatcity.com (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).
  • Seefelt, Beth at May 20, 2002 at 3:23 pm
    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-----
    Sent: Monday, May 20, 2002 10:03 AM
    To: Multiple recipients of list ORACLE-L

    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: Seefelt, Beth
    INET: Beth.Seefelt_at_TetleyUSA.com

    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: ListGuru_at_fatcity.com (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).
  • Mark Leith at May 20, 2002 at 3:23 pm
    SQL Server to Oracle DBUse 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..

    HTH

    Mark
    -----Original Message-----
    From: root_at_fatcity.com On Behalf Of Richard
    Huntley
    Sent: 20 May 2002 15:03
    To: Multiple recipients of list ORACLE-L
    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.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Mark Leith
    INET: mark_at_cool-tools.co.uk

    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: ListGuru_at_fatcity.com (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).
  • Tim Gorman at May 20, 2002 at 5:43 pm
    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.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.com

    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: ListGuru_at_fatcity.com (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).
  • Jared.Still_at_radisys.com at May 20, 2002 at 7: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"
    Sent by: root_at_fatcity.com
    05/20/2002 10:43 AM
    Please respond to ORACLE-L



    To: Multiple recipients of list ORACLE-L
    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.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 -----
    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: Jared.Still_at_radisys.com

    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: ListGuru_at_fatcity.com (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).
  • KENNETH JANUSZ at May 20, 2002 at 7:55 pm
    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"
    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"
    Sent by: root_at_fatcity.com
    05/20/2002 10:43 AM
    Please respond to ORACLE-L


    To: Multiple recipients of list ORACLE-L
    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.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 -----
    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: Jared.Still_at_radisys.com

    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: ListGuru_at_fatcity.com (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: kjanusz_at_att.net

    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: ListGuru_at_fatcity.com (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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 20, '02 at 2:03p
activeMay 20, '02 at 7:55p
posts11
users10
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase