Post reply

refreshing data on publisher database

  • March 17, 2009 at 12:06 pm

    #201923

    Hi,

    I have transactional replication set up on a database which needs data refresh from prod environment. I went through this article http://msdn.microsoft.com/en-us/library/aa237094(SQL.80).aspx - Here the backup of same database was asked to restore.

    If backup from different server is used then it would break the replication.

    Without dropping and recreating the subscriptions, are there any other options available to perform this task?

  • March 19, 2009 at 10:37 am

    #962893

    Hi ShankMonk, Got a question for you. When you say you want to refresh the Data from Prod, are you talking about different tables that are not replicated or are you trying to Refresh data in Publisher that is not in the production environment with latest data?

    -Roy

  • March 23, 2009 at 8:21 am

    #964444

    I'm trying to refresh latest data from Production to DEV publisher which includes data from all tables.

    I used RedGate to synchronize data. But I need conventional method to do it.

    Thanks.

  • March 23, 2009 at 8:28 am

    #964453

    You can do a reinitialize data. Snapshot with Truncate in the Destination table to get this done.

    -Roy

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

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