Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server Tables to Oracle Database
A tool like InfoMaker has a nice pipeline facility which makes it very easy
to transfer data between any 2 databases.
Another option might be Heterogeneous Services. Then the SQLServer can be accessed through a database link.
-- Terry Dykstra (TeamSybase) http://powerbuilder.codeXchange.sybase.com/ http://www.pb9books.com Enhancement Requests: http://www.isug.com/cgi-bin/ISUG2/submit_enhancement "Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message news:RQuab.1818$D8.1000_at_bignews3.bellsouth.net...Received on Thu Sep 18 2003 - 22:58:24 CDT
> As others have mentioned, the dts package is a good way.
>
> But, something this small in size could be done a lot of ways and quickly.
>
> One simple way that comes to mind is use MS Access . Link the tables in
> sqlserver into MS Access and then do a "save as/export" to external odbc
dsn
> which is the Oracle database. Gets the data, but watch out for case
> sensitive table names or with blanks. They get setup in Oracle that way
and
> dealing with case sensitive table names or column names is a pain usually.
>
> Note: I know this way works with a simple Access table, but I am not
> positive about a sql server linked table . Seems it should work.
>
> --
> "Kalle" <kk.kk_at_kk.com> wrote in message news:3F698AF8.F52E776F_at_kk.com...
> > 5 tables and biggest table is about 0.5meg
> >
> > sql version is 6.5 and oracle 8.1.7
> >
> >
> >
> > Niall Litchfield wrote:
> >
> > > "Kalle" <kk.kk_at_kk.com> wrote in message
news:3F69787B.211AAF6D_at_kk.com...
> > > > Hi all,
> > > >
> > > > I need to copy the data from SQL Server tables to Oracle Database.
> > > >
> > > > What should I do, of course I prefer the easiest way :-)
> > >
> > > How much data and what versions?
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> >
>
>