Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle to SQL Server.

Re: Oracle to SQL Server.

From: Murali Kazhipurath <murali_at_jps.net>
Date: 1998/02/08
Message-ID: <34de18c5.0@blushng.jps.net>#1/1

Greg,

If it is a one time transfer, you can use a tool like MS Access to transfer the data. But if you want to do it repeatedly, I would recommend you to use a combination of SQl*Plus and bcp (SQL Server utility). This will let you write scripts and make the process very smooth. On the other hand, it will require a little bit of extra work. But like I said, if you are going to repeat the process many times, it might save you time.

Murali Kazhipurath
(murali_at_jps.net)

Greg Parsons wrote in message <34D9D6BC.14D7E33B_at_intermetrics.com>...
>Hello,
> We're looking for a way to move a few tables from Oracle into SQL
>Server. What tools are available?
> Any help would be appreciated.
>Thank you. Greg
Received on Sun Feb 08 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US