Home Forums SQL Server 2005 Administering Replicate from Non-Partioned Table (Publisher) to a Partitioned Table (Subscriber) RE: Replicate from Non-Partioned Table (Publisher) to a Partitioned Table (Subscriber)

  • You may need to initialize the Subscription without a Snapshot or with special Schema Options such that the DDL is not affected on the Subscriber when initialized but other than that consideration I cannot see why that would be a problem. Replication of the data itself occurs at the DML level so the Distributor is just sending the commands across and has no interest in the underlying physical implementation of the table.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato