sql server replication: Oracle replication problem -- sql server replication

Oracle replication problem

andrew.simmons NO[at]SPAM monitorbm.co.nz
6/27/2006 9:37:13 PM

sql server replication:

I'm having severe troubles getting replication to work reliably from
SQL Server 2000 to Oracle. I've configured the replication to work
periodically rather than continuously. The basic issue is that every
time the replication is activated, an attempt is made to create the
table msrepl7, and since the table already exists the replication
fails. If I manually drop the table on the Oracle server, then the next
periodic replication works fine, but then subsequent ones fail because
the table has been re-created. Any suggestions on how to fix this
problem gratefully accepted.

Re: Oracle replication problem

Hilary Cotter
6/28/2006 12:00:00 AM

Hi Andrew

I am an ex pat from New Plymouth.

There was a similar problem for MySQL with SQL 2000 replication. I suggest
you contact Microsoft about it.

I did not encounter this problem with SQL 2000 to Oracle however.

--
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

[quoted text, click to view]