Posted by Crazy Cat on 12/28/05 15:31

brogdonm wrote:
> Hi everyone. I need to be able to query a database in Oracle and then
> actually save the data in an MS SQL database, does anyone know what is
> the best way to do this? Would it be best to do everything internal
> (inside MS SQL) or external (with some script: javascript, vbscript,
> perl)?
>
> Thanks in advanced,
> Mike

It depends on what additionally you want to do with the data. If you
are looking to simply replicate your Oracle data in MS SQL Server use
DTS. If you are looking to present the data, say in a web page, you
might want to use any of the various scripting languages.
You'll still end up doing quite a bit internally, probably with views
and stored procedures.
That's my guess.

Thanks

• Next in forum: Re: Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
• Prev in forum: Re: MS OLE DB for ODBC with Oracle ODBC source headaches
• Thread view: Re: Oracle/MS SQL Interface

[Reply to this message]