Merge Replication - Update Database

  • Hello All,

    Interesting problem I have is as follows;

    1 Publisher/distributor with 5 subscribers. I want to update the publishing database, add tables/columns/fields and want these changes to go back to the subscribers.

    I know that you can use special stored procedures to do this but is it better to just recreate the subscriptions? The links between all machines are T1.

    Speed is most important since an upgrade of the data would need to be done within 10 hours, replicated to all sites. Any ideas?

  • Would depend on how long your snapshots take to complete.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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