Oracle replication problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrew.simmons@monitorbm.co.nz - 28 Jun 2006 05:37 GMT

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.

Reply to this Message

Hilary Cotter - 28 Jun 2006 12:13 GMT

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.

Signature

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

> I'm having severe troubles getting replication to work reliably from
> SQL Server 2000 to Oracle. I've configured the replication to work
[quoted text clipped - 5 lines]
> the table has been re-created. Any suggestions on how to fix this
> problem gratefully accepted.

Reply to this Message