We had the below error in my environment during cross domain pull transactional replication. To resolve this we have the below two options.
First Method
1) Generate the snapshot and manually copy the same to subscriber.
2) Change the Snapshot Location in the subscriber properties. Since the snapshot location is local, it will apply the same very fast.
Second Method
1) Keep the replication as it is.
2) Generate the BCP out of the articles.
bcp BCP_Tran.dbo.Test out c:\Test.dat -c -U sa -P <Pword>-S <Srvr Name>
3) Apply the BCP file to the subscriber.
bcp BCP_Tran.dbo.TestNew in c:\Test.dat -T -c -S <Server Name>
No comments:
Post a Comment