Transactional Replication do and don'ts

Question

Transactional Replication do and don'ts

virtualpm

Grasshopper

Points: 24
More actions
February 10, 2010 at 9:36 am

#220438

Hello,
We have a need to capture all transactions of staging database in a Data warehouse setting. We are thinking about implementing Pull Transactional Replication, however we do not want to replicate any deletions. My question - is there anyway to avoid replicating deleted records? Also any insight about do and don'ts of transactional log.
Any feedback is greatly appreciated.
Nagesh

Viewing 6 posts - 1 through 5 (of 5 total)

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

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

Your post is confusing. You seem to mix-up the terminology here.

virtualpm (2/10/2010)
Hello,
We have a need to capture all transactions of staging database in a Data warehouse setting. We are thinking about implementing Pull Transactional Replication, however we do not want to replicate any deletions. My question - is there anyway to avoid replicating deleted records?

You cannot replicate only Insert / Update transaction is Transactional Replication, you cannot avoid one type (delete) of DML Statements.

Also any insight about do and don'ts of transactional log.
Any feedback is greatly appreciated.
Nagesh

Are you talking about Transaction Log OR Transactional Replication? There is nothing like Transactional Log (you have combined both of them)..

I do not not know the level of your understanding towards them, read few articles about both of them to better know about them..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 2

Bru, Just one correction....

You said that

You cannot replicate only Insert / Update transaction is Transactional Replication, you cannot avoid one type (delete) of DML Statements.

Actually it is possible to say do not replicate delete commands.

This is used when Business needs a lean and mean database for OLTP. They sometimes delete off all historical data more than a week and keep all the historical data in another server.

-Roy

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

Thanks Roy for correcting.. I am not aware of that..

Learned a point..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 4

Some options:

http://www.replicationanswers.com/Transactional.asp

virtualpm Grasshopper Points: 24 More actions · Answer 5

Thanks for the responses. I believe we are going with transactional replication without replicating deleted records.