Re: SQL Server Tables to Oracle Database

Is there a way to do it in a procedure or function? I am hitting 14 SQL Servers and pulling the data over to a central SQL Server but need to convert my SQL Server to Oracle 8.1.7 and haven't found a way to get the data as yet.

Regards,
Ron Hagerman
http://www.rons-sandbox.com

"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca> wrote in message news:A9vab.2831$Vr3.36864_at_news1.telusplanet.net...
> 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...
> > 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
> > >
> >
> >
>
>
Received on Sun Sep 21 2003 - 11:24:55 CDT