Groups | Blog | Home
all groups > sql server replication > june 2004 >

sql server replication : SQL Server Replication To Oracle


Viplove Desa
6/14/2004 1:13:30 PM
I am running Snapshot replication. I can generate a
snapshot successfully. When I try to start the Distributor
I get following error

"f:\MSSQL\ReplData\unc\FSIREG4SNTSA_CAMPUS7_CAMPUS7_REG4_TO
_HR_ORACLEDB\20040614155834\fsipeoplexref_1.sch
Transaction sequence number and command ID of last
execution batch are 0x0000693A000010D8008800000001 and 4."

Any Help is appreciated
Hilary Cotter
6/14/2004 10:49:10 PM
you are having a problem applying the snapshot. Oracle is sometimes a little
finiky with creating the schema. To get around this you might want to try to
dts the table and data over to begin with. Then do a nosync subscription.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

AddThis Social Bookmark Button