SQL 2005 One Way Replication

[RG]

Is it possible to configure replication to take place at certain time, once
a day?

Is it possible configure replication for inserts and updates, but not
deletes?

Thanks in advance

[Ben Thul]

Post by RG
Is it possible to configure replication to take place at certain time, once
a day?

Yes, it is. You can either set up snapshot replication which will, in
essence, take a copy of the data at that time and put it on the
subscriber, or you can do transactional replication and have the agent
run at a specified time. I'd recommend the former as that way you
don't have to keep data changes as they happen throughout the day (and
as such it'll be much easier/faster to apply the changes at the
subscriber). You'd also have the problem of telling the distribution
agent when to stop with a transactional replication topology.

Post by RG
Is it possible configure replication for inserts and updates, but not
deletes?

Yes. When you set up an article in transactional replication, you
specify the commands that are run at the subscriber for each of
insert, update, and delete to replicate the changes for that article.
In order to not replicate deletes, you could no-op the delete command
for that article.

HTH,
Ben

[RG]

Thanks for your help. Could you point me to sample configuration of this.

Post by Ben Thul

Post by RG
Is it possible to configure replication to take place at certain time, once
a day?

Yes, it is. You can either set up snapshot replication which will, in
essence, take a copy of the data at that time and put it on the
subscriber, or you can do transactional replication and have the agent
run at a specified time. I'd recommend the former as that way you
don't have to keep data changes as they happen throughout the day (and
as such it'll be much easier/faster to apply the changes at the
subscriber). You'd also have the problem of telling the distribution
agent when to stop with a transactional replication topology.

Post by RG
Is it possible configure replication for inserts and updates, but not
deletes?

Yes. When you set up an article in transactional replication, you
specify the commands that are run at the subscriber for each of
insert, update, and delete to replicate the changes for that article.
In order to not replicate deletes, you could no-op the delete command
for that article.
HTH,
Ben

[Ben Thul]

Sample configurations are going to be tricky, but I can point you to
the relevant places in books online (BOL):

Snapshot replication: http://technet.microsoft.com/en-us/library/ms151847%28SQL.90%29.aspx

For not replicating the delete commands, the relevant doc is for
sp_addarticle: http://technet.microsoft.com/en-us/library/ms173857%28SQL.90%29.aspx,
specifically the @del_cmd parameter.

The docs for 2000 are going to be found in BOL as well (but the SQL
2000 BOL, of course). Good luck!
--
Ben

Thanks for your help.  Could you point me to sample configuration of this.

Post by RG
Is it possible to configure replication to take place at certain time, once
a day?

Yes, it is.  You can either set up snapshot replication which will, in
essence, take a copy of the data at that time and put it on the
subscriber, or you can do transactional replication and have the agent
run at a specified time.  I'd recommend the former as that way you
don't have to keep data changes as they happen throughout the day (and
as such it'll be much easier/faster to apply the changes at the
subscriber).  You'd also have the problem of telling the distribution
agent when to stop with a transactional replication topology.

Post by RG
Is it possible configure replication for inserts and updates, but not
deletes?

Yes.  When you set up an article in transactional replication, you
specify the commands that are run at the subscriber for each of
insert, update, and delete to replicate the changes for that article.
In order to not replicate deletes, you could no-op the delete command
for that article.
HTH,
Ben

[RG]

Also, can you the same in SQL 2000

Post by Ben Thul

Post by RG
Is it possible to configure replication to take place at certain time, once
a day?

Yes, it is. You can either set up snapshot replication which will, in
essence, take a copy of the data at that time and put it on the
subscriber, or you can do transactional replication and have the agent
run at a specified time. I'd recommend the former as that way you
don't have to keep data changes as they happen throughout the day (and
as such it'll be much easier/faster to apply the changes at the
subscriber). You'd also have the problem of telling the distribution
agent when to stop with a transactional replication topology.

Post by RG
Is it possible configure replication for inserts and updates, but not
deletes?

Yes. When you set up an article in transactional replication, you
specify the commands that are run at the subscriber for each of
insert, update, and delete to replicate the changes for that article.
In order to not replicate deletes, you could no-op the delete command
for that article.
HTH,
Ben