Re: Oracle/MS SQL Interface
- From: "Crazy Cat" <danbredy@xxxxxxxxxxx>
- Date: 28 Dec 2005 05:31:03 -0800
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
.
- References:
- Oracle/MS SQL Interface
- From: brogdonm
- Oracle/MS SQL Interface
- Prev by Date: Re: MS OLE DB for ODBC with Oracle ODBC source headaches
- Next by Date: Re: Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
- Previous by thread: Re: Oracle/MS SQL Interface
- Next by thread: Re: Oracle/MS SQL Interface
- Index(es):
Relevant Pages
|
