SQL 2005 One Way Replication

Discussion in 'microsoft.public.sqlserver.replication' started by RG, Jul 6, 2010.

  1. RG

    RG Guest

    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
     
    RG, Jul 6, 2010
    #1
    1. Advertisements

  2. RG

    Ben Thul Guest

    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.
    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, Jul 6, 2010
    #2
    1. Advertisements

  3. RG

    RG Guest

    Thanks for your help. Could you point me to sample configuration of this.
     
    RG, Jul 6, 2010
    #3
  4. RG

    RG Guest

    Also, can you the same in SQL 2000

     
    RG, Jul 6, 2010
    #4
  5. RG

    Ben Thul Guest

    Ben Thul, Jul 6, 2010
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.