Re: SQL Server Tables to Oracle Database

"Phoenix" <me_at_here.com> wrote in message news:bkkjec$jvv$1_at_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

sean_at_cnfei.com

-----= 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! =----- Received on Mon Oct 06 2003 - 14:42:23 CDT