Post reply

Schema changes with transactional replication

  • June 15, 2015 at 4:46 pm

    #318207

    How do we know our schema changes will propagate to subscriber without breaking the replication?

    Is there any t-sql command to find out the option true or false?

    We are dropping a column in publisher table

  • June 16, 2015 at 3:36 pm

    #1805911

    You need to check the 'replicate_ddl' setting for the publication.

    This can be done by querying the syspublications table.

    Sp_repldropcolumn can be used to drop a column in a replicated table.

    Cheers

    Vultar

  • June 16, 2015 at 3:58 pm

    #1805918

    If we add any new views in publisher db and I want to replication to subscriber, how can we do it?

    Is it require adding those views as articles and take new snapshot?

    If I create the view manually on subscriber db is it fails?

    Ours is not updatable subscriber

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

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