SQL Replication

Posted on 2012-08-13
Last Modified: 2012-09-18
I am setting up replication. I have a few questions.
Can i make changes on the sql subscriber?
Can i change the table structure?
Question by:aneilg
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Can i make changes on the sql subscriber?
    If the object is replicated you should not make any changes on the Subscriber.

    Can i change the table structure?
    It depends.  What changes are you making?  If if requires rebuilding the table, then no.
    LVL 15

    Accepted Solution

    DDL changes are not permitted at subscriber, They are generally done at the publisher. For DML changes,  you can change the data at subscriber, but the synchronization depends on the type of replication you are using. Merge replication and Updatable transactional replication allows the DML changes originated at subscriber to replicate to the publisher, where as other replication types does not replicate these changes.

    Although, in merge replication you can control how subscriber should handle the DML changes.

    Bidirectional (the default): changes can be downloaded to the Subscriber and uploaded to the Publisher. This property is called "Synchronization direction" , this is done at the article level.

    Download-only to Subscriber, prohibit Subscriber changes: changes can be downloaded to the Subscriber, but they cannot be uploaded to the Publisher. Triggers prevent changes from being made at the Subscriber.

    Download-only to Subscriber, allow Subscriber changes: changes can be downloaded to the Subscriber, but they cannot be uploaded to the Publisher.

    Author Comment

    thanks guys, Exactly the information i needed.

    Author Closing Comment


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now