SQL Server Tables to Oracle Database
Kalle
I need to copy the data from SQL Server tables to Oracle Database.
What should I do, of course I prefer the easiest way :-)
Rgds
Kalle
Niall Litchfield
> 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
Kalle
sql version is 6.5 and oracle 8.1.7
Niall Litchfield
and use sqlloader. The more data you have the more sqlloader becomes
attractive.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Kalle" <kk...@kk.com> wrote in message news:3F698AF8...@kk.com...
Burt Peltier
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.com> wrote in message news:3F698AF8...@kk.com...
Terry Dykstra
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" <burttemp1...@bellsouth.net> wrote in message
news:RQuab.1818$D8....@bignews3.bellsouth.net...
Phoenix
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...@forestoil.ca> wrote in message
news:A9vab.2831$Vr3....@news1.telusplanet.net...
Daniel Morgan
>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
>
>
>
For the benefit of the rest of us ... what is 14 SQL Servers? 14
instances? 14 databases (schemas in Oracle)?
From my experience the best way to move data between the two is
SQL*Loader. But only after the data
extracted from SQL Server has been cleansed of all of the hidden lower
ASCII characters that SQL Server
seems oblivious to.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)
Sean Chang
news:bkkjec$jvv$1...@eskinews.eskimo.com...
> 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
>
Hi, Ron,
It depends what procedures you need:
I manage lots of data transfer between Sqlserver 2k and Oracle 817 by using
OLE DB and Visual Basic. The coding is simple (have sample code if you
want),
you simply make an EXE file and schedule it in a Windows PC, works great for
me.
If you are talking about Oracle stored procedure, I think you can code a
Java program
to transfer data between Oracle and SS, make the jave program as a stored
procedure
in Oracle and use DBMS_JOB to schedule transfer. I have done that before and
Prefer
VB solution. ( less coding).
Hope this helps
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----