Post reply

Replicating data to a table via a view

  • August 11, 2014 at 12:17 pm

    #289700

    I am trying to replicate data from a view in the publisher to a table in the subscriber (transaction replication). I do not need the view's base table, or the view itself, replicated to the subscriber. I only want to data from the view to feed a table in the subscriber.

    Is this possible?

    Running SQL Server 2008 R2 Enterprise.

    Thanks!

  • August 11, 2014 at 12:27 pm

    #1736993

    Is your view materialized?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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