Partition Existing Replicated Table

Partition Existing Replicated Table.

To create partition in existing replicated table you must have to remove article from replication. The reason is, to create partiiton in existing table you must have to recreate primary key and you can’t recreate primary key replicated table.

so, remove table from replication is first step.

Note : Before you remove article from replicatin please check file group on both database at publisher and subscrber.

You must have multiple filegroup on replicated database and both database must have same filegroup.

1) You must remove existing table from replication.
http://nirav.extreme-advice.com/2013/07/11/remove-article-from-replication/

2) Create Parition on existing table.
http://nirav.extreme-advice.com/2013/07/09/partition-in-existing-table-in-sql-server/

3) Add partitioned table to replication.

http://nirav.extreme-advice.com/2013/07/10/add-partitioned-table-in-replication/