replication and bulk insert

Question

Post reply

replication and bulk insert

Clint-525719

SSCrazy

Points: 2924
More actions
July 13, 2009 at 1:47 pm

#212313

I've read that doing bulk inserts will not cause certain triggers to fire whil running merge replication, so therefore, whatever you inserted will not be replicated to the subsrciber.
Would this be true for transactional replication also?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Erik Bitemo SSCrazy Points: 2062 More actions · Answer 1

Hi,

Transactional replication works by reading the transaction log, not using triggers, so it shouldn't be a problem.

-- Erik http://blog.rollback.hu

Clint-525719 SSCrazy Points: 2924 More actions · Answer 2

see this:

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/5bc36369-8c53-41aa-9304-0b9c7205ec3d

Erik Bitemo SSCrazy Points: 2062 More actions · Answer 3

With all respect, I don't see why bulk insert would cause problem in TRANSACTIONAL REPLICATION. I read Hilary's answer, but still... Can you shed some light on this for me, please?

Thanks,

-- Erik http://blog.rollback.hu