| Author |
to move data between oracle and mssql with biztalk Server 2004
|
|
| Thomas Niemann 2004-10-27, 7:46 am |
| Hello Group,
can someone tell me where to fin a simpledokumentation on how to move data
between oracle and mssql with biztalk Server 2004.
Thank you in advance
Thomas Niemann
| |
| Jeff Lynch 2004-10-27, 7:46 am |
| You might be better off using SQL Server 2000 DTS (data transformation
services) to move data from an Oracle DB to a SQL DB. BizTalk is usually
used for "transactional" data while SQL DTS is used for data warehouse ETL
(extraction, transformation and loading).
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/
"Thomas Niemann" <niemann.thomas@gmnx.de> wrote in message
news:O73t5XAvEHA.2016@TK2MSFTNGP15.phx.gbl...
> Hello Group,
>
> can someone tell me where to fin a simpledokumentation on how to move data
> between oracle and mssql with biztalk Server 2004.
>
> Thank you in advance
>
> Thomas Niemann
>
>
>
| |
| Thomas Niemann 2004-10-27, 5:49 pm |
| Thx, but i do have to use the BIZTALK Server because it is for transactional
data...
"Jeff Lynch" <jeff.lynch@houston-lynch.com> schrieb im Newsbeitrag
news:%23B8enNCvEHA.1308@TK2MSFTNGP09.phx.gbl...
> You might be better off using SQL Server 2000 DTS (data transformation
> services) to move data from an Oracle DB to a SQL DB. BizTalk is usually
> used for "transactional" data while SQL DTS is used for data warehouse ETL
> (extraction, transformation and loading).
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://dotnetjunkies.com/WebLog/jlynch/
>
>
> "Thomas Niemann" <niemann.thomas@gmnx.de> wrote in message
> news:O73t5XAvEHA.2016@TK2MSFTNGP15.phx.gbl...
data[vbcol=seagreen]
>
>
| |
| Pieter van der Merwe 2004-10-31, 2:46 am |
| Have a look at www.topxml.com/biztalkutilities
Cheers
"Thomas Niemann" <niemann.thomas@gmnx.de> wrote in message
news:uuENJJDvEHA.2564@TK2MSFTNGP12.phx.gbl...
> Thx, but i do have to use the BIZTALK Server because it is for
> transactional
> data...
>
>
> "Jeff Lynch" <jeff.lynch@houston-lynch.com> schrieb im Newsbeitrag
> news:%23B8enNCvEHA.1308@TK2MSFTNGP09.phx.gbl...
> data
>
>
|
|
|
|