Then I'd probably either setup a dts package in sqlserver or dump to .csv
and use sqlloader. The more data you have the more sqlloader becomes
attractive.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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
>
Received on Thu Sep 18 2003 - 05:49:02 CDT
