replication - does it drop/create objects?

  • We have transaction replication set up. If i need to re-setup , would it drop/recreate objects on the subscriber or just lock the objects and apply the changes?

  • The answer is yes to all of your options.

    Depending on what options you choose, replication can be told to drop tables, truncate tables, delete from tables. when you create the subscription, these are all options that you can select when replicating tables.

    Can't quite remember what the options are for views, sprocs.

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

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