Can I add a delay to sql server transactional replication ?

views:

answers:

+1 Q:

Can I add a delay to sql server transactional replication ?

I've got transactional replication configured from a database called DBProd to another database called DBWarehouse ; everything works fine, and transaction are usually replicated instantaneously to the warehouse .... which is my problem.

I'd like to add a slight delay to the replication (something like 10 minutes), so that the replicated database can be used to access a previous version of the database (in case a bug occurs for example)

Is there a simple way to achieve this ?

+3 A:

You should be able to do this in the Subscriber Scheduling options.

Ardman 2010-05-04 16:05:27

I haven't found where to do that yet. The job is constantly running to replicate transactions, and launching it periodically wouldn't achieve the desired result (ie if a modification is done right before the scheduled update time, it will be replicated almost immediately)

Brann 2010-05-04 16:13:26

Here is a nice step-by-step walkthrough:http://www.codeproject.com/KB/database/sql2005-replication.aspxIt has the Synchronization Schedule (at the end) where you can configure the settings.

Ardman 2010-05-04 16:24:51

@Ardman : thanks ; but I can't see how this would address the issue raised in my comment (ie if a modification is done right before the scheduled update time, it will be replicated almost immediately).Wouldn't that be a problem ?

Brann 2010-05-04 16:32:13

@Brann: my understanding of the delay was that it wouldn't replicate until the time has passed. I maybe wrong with this one.

Ardman 2010-05-05 07:26:04

ansaurus

tags:

views:

answers:

Can I add a delay to sql server transactional replication ?

related questions