"Sam Davis" <SamDavis@discussions.microsoft.com> wrote in message
news:69202E38-E50C-463B-9141-D057190BDC41@microsoft.com...
> But to clarify.. Do you have to have the EE verison of SQL 2005 in order
> to
> replicate from an Oracle database to a SQL database? Is it just
> transactional
> which requires EE or all forms? Thanks Hilary for responding!
>
> "Hilary Cotter" wrote:
>
>> All versions except mobile and express allow publications from SQL server
>> to
>> SQL or other RDBMs. You can also write your own distribution interface so
>> that other RDBMs can replicate to SQL Server and from there to other
>> RDBMs.
>>
>> SQL Server 2005 EE allows snapshot and transactional replication from
>> Oracle
>> to SQL Server and from there to other RDBMs.
>>
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>>
>>
>> "Sam Davis" <SamDavis@discussions.microsoft.com> wrote in message
>> news:1DAD6240-9D22-4A4E-8E6F-3A0540E2F107@microsoft.com...
>> >I am looking for clarification on Microsoft stance that SQL 2005 can
>> > replicate from an Oracle database. Some of the literature says that you
>> > have
>> > to have Enterprise in order to perform Transactional Replication. Is it
>> > just
>> > Transactional Replication that requires Enterprise or is it all types.
>> > Snapshot etc..
>> >
>> > Thanks!
>>
>>
>>