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 <F1> whilst on the screen..
HTH
Mark
Mark
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard Huntley
Sent: 20 May 2002 15:03
To: Multiple recipients of list ORACLE-L
Subject: SQL Server to Oracle DBAnyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB?
Thanks.
