Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server Tables to Oracle Database
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...Received on Thu Sep 18 2003 - 22:37:24 CDT
> 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
>