July 15, 2010 at 11:45 am
I created a snapshot replication from production server to datawarehouse. The snapshot is created successful and data is replicated to destination server at the first time. After that, the replication stops working and no error message. In action message " No replicated transactions are available"
Please help me. I am pulling my hair out everyday.
July 15, 2010 at 10:24 pm
To me, this sounds like everything is working correctly. Snapshot replication is only intended to deliver the content of the tables as they were on the publishing database when the snapshot was taken. Any changes to the source database following that are of no relevance.
If you want a continual feed to changes from the publishing database, you should consider a different replication model (e.g. transactional replication)
July 16, 2010 at 7:06 am
Just adding to it, You could set up the snapshot agent to run in the night to snapshot the data again to your warehouse. But this is NOT recommended for Large DB. It is also not recommended if you need the data changes real time. I think HappyCat59 gave you the right suggestion for your case.
-Roy
July 16, 2010 at 8:10 am
Transaction Replication does not allow me to copy Tables without primary key. Any suggestions? I have to replicate tables which do not have primary key.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply