Oracle-L: RE: SQL Server to Oracle DB

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 20 May 2002 07:23:33 -0800
Message-ID: <F001.004648FC.20020520072333@fatcity.com>

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 <F1> whilst on the screen..

HTH Mark
  -----Original Message-----
  From: root_at_fatcity.com [mailto: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). Received on Mon May 20 2002 - 10:23:33 CDT