Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move SQL Server Tables to Oracle

Re: Move SQL Server Tables to Oracle

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 18 Sep 2003 11:59:44 -0800
Message-ID: <F001.005D0668.20030918115944@fatcity.com>

If you are familiar with Perl and DBI, you can pre-create the tables in Oracle, open a connection to both the MS and Oracle databases, select from MS, insert to Oracle.

Do it all in one step, it's pretty straightforward.

Jared

On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote:
> Hi all,
>
> I need to move some sql server tables to oracle.
>
> Do you have some ideas how to do it. I have no idea ...
>
> rgds
> G
>
>
> ---------------------------------
> Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Sep 18 2003 - 14:59:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US