Schema Question

  • Do the publisher and subscriber have to have the same database schema?


    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis

  • Yes!


    Kindest Regards,

  • No they do not have to be the same. 

    You can change the table name if you are using transactional replication.

    You may elect to publish some of the columns of a table (vertical filtering)  as well.

    Depending on the options you take, you may elect to have constraints, indexes, triggers defined on the replica.

     

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

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