Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2009-08-31 : 17:11:36
|
| I have a merge replication setup, which synchronizes via Web Synch. I just added 4 indexes to a table on the published database that is already in in the articles of publication. When I synchronized the subscription, the indexes did not appear on the subscribed database. The table article is setup by default to copy both clustered and non-clustered indexes.Do I have to create and send a new snapshot? If I do, will it need to download the entire database via web synch again, or will it only download the changed table? Some of the unaffected tables contain a lot of data, so I am wondering if there is a way to synchronize the indexes without having to create a new snapshot, which may not work via Web Synch due to the amount of data that would need to be sent for the entire snapshot.I already know how to upload a snapshot manually to the subscriber so that is my plan if I have to reload from a snapshot. I was just surprised to see that a normal synchronization would pick up on the addition of a column to a table, but not an index.TIA,Ken |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
Posted - 2009-09-01 : 07:49:24
|
| I did not realize I could do that since I could not make schema changes on the subscriber. Thanks Tara. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Replicate indexes via synchronization
Tara Kizer