Hi Kim - can you try this on any other database other than MASTER - also confirm that the recovery model of the database is Full - take a backup of the database first ...
Read the document GoldenGate Microsoft SQL Server Installation and Setup Guide
It has more details on what's required to set up GoldenGate on SQL Server ...
"The SQL Server database must be set to the full recovery model, and at least one full database backup must be done before GoldenGate"
I do not suppose you have done this the other way around , Oracle to SQLServer
I am trying to do just that and cannot get my replicat to connect to the target db
C:\temp\GoldenGateMSTarget>replicat paramfile C:\temp\GoldenGateMSTarget\dirprm\
initrep.prm
gives the error
2011-02-09 13:46:35 ERROR OGG-01557 OLE DB Error: Cannot open data source. E
rror code 0x80040e73 Detail: OLE DB: GetDataSource.
initrep.prm
SPECIALRUN
END RUNTIME
sourcedb pktest3
EXTFILE C:\temp\GoldenGateMSTarget\dirdat\ex
sourcedefs C:\temp\GoldenGateMSTarget\dirdef\tcustmer.def
MAP schema1.tcustmer, TARGET schema1.tcustmer;
any help would be appreciated
7 Comments