Re: Oracle to SQL Replication.

Yes, You need Enterprise Edition to do Oracle publishing. Only snapshot and
transactional are supported.

--
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:69202E38-E50C-463B-9141-D057190BDC41@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1DAD6240-9D22-4A4E-8E6F-3A0540E2F107@xxxxxxxxxxxxxxxx
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!





.

Relevant Pages

  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... If i do this in Query Analyser should i have the DB closed? ... Now regarding Replication, i am brand new to this... ... And then stop and start SQL Server. ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.access.replication)
Loading