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)

  • The only way I know you can set up a replication by creating a snapshot or initialize with backup. In both cases you have to have the same schema in subscriber as in publisher.But once you have the replication set up, then partition the table in subscriber.

    Haven't done that by myself so can not say for sure that it will work or not but worth trying.