Post reply

2 questions on Replications

  • August 10, 2011 at 3:35 am

    #255486

    Hello,

    I have 2 questions on SQL Server Transactional Replication :

    (1)Can the Publisher only replicate INSERT, UPDATE but not DELETE ?

    (2)Does Transactional Replication also replication the DDL changes ? For example, if I create a new table at the Publisher, will this new table be replicated to the Subscriber automatically ?

    Thanks.

  • August 10, 2011 at 3:47 am

    #1366441

    Hi,

    1) No, it can replicate all 3.

    2) Yes if you set up replicate schema changes to TRUE.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • August 10, 2011 at 4:00 am

    #1366452

    Thanks.

  • August 10, 2011 at 4:57 am

    #1366464

    2) If you create a new table at the Publisher, it will NOT be replicated to the Subscriber automatically. You have to manually add it to one of the publications.

    If you make any schema changes to the existing article, those schema changes would get replicated.

  • August 10, 2011 at 7:48 pm

    #1367027

    Thanks for your reply.

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

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