I have replicated 315 tables. Data comes over, primary keys come over. Other indexes do not come over. Did I miss something? Is my only recourse to script them out and run the script(s) on subscriber? Is there a quick way to script them out.
I have replicated 315 tables. Data comes over, primary keys come over. Other indexes do not come over. Did I miss something? Is my only recourse to script them out and run the script(s) on subscriber? Is there a quick way to script them out.
When you create the publication you have to specify which articles you want to have the indexes come across for.
Edit your publication. Select Articles. Select the Article Properties button/dropdown. Select the All Tables option. Turn on the clustered and nonclustered indexes. Then rerun the snapshot and push it out to the subscribers.
Replication does NOT replicate indexes automatically. Check this thread here. also you have to set copy clustered and non clustered indexes to true.
No one has followed this question yet.