Post reply

Update data during replication

  • June 30, 2008 at 9:48 am

    #209215

    Hi guys,

    I've set up snapshot replication between two databases on the same SQL 2000 server. Database A has an email address column that I would like to overwrite during the replication process to Database B. I know it is possible to apply a post-snapshot script however, I'd like to keep this tidy and if possible, wrap this all up in my existing publication job. Is this possible?

    Any help would be very much appreciated.

    Thanks,

    James

  • July 1, 2008 at 4:32 am

    #836539

    Hi,

    Can't you simply add a job that will update the column after the snapshot has run?

    HTH

    Graeme

  • July 1, 2008 at 7:37 am

    #836676

    Hi Graeme,

    I've added that part in as an additional job to the replication process and it works perfectly.

    Thanks,

    James

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

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