Post reply

Data is not getting replicated to Subscriber

  • April 25, 2008 at 2:01 pm

    #189633

    I am setting up a Transaction replication and testing how it works.

    Server A is a publisher and Server B is a Subscriber. Distribution database is on Server A

    I put a filter condition on one of the artile that if the date is greater then current then don't replicate the data to subscriber.

    So when the replication started it delete the old data on subscriber means data before the current date and added data after the current date.

    Now I remove the filter but it is still behaving the same way. I want all the data from publisher to replicate to Subsriber.

    What should I do to keep old data in the subscriber and just replicate the data which is after the current date.

    any help will be appreciated.

  • April 28, 2008 at 10:48 am

    #807933

    are you using snapshot with your transactional replication?

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

  • April 28, 2008 at 11:02 am

    #807948

    Yes, I am using snapshot in the replication.

    Here is my goal.

    1. I wanted to replicate data in batches. Every week around 2 million records should be replicated from publisher to subscriber.

    2. Keep the data in the subscriber database and replicate from the publisher based on the weekend date. so only weekend data gets replicated. Subscriber data should not deleted.

    Please let me know what setup should I take to make is success.

    Thanks

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

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