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 |
|
Nazim
A custom title
1408 Posts |
 Posted - 2003-07-24 : 11:59:10
|
| Merge Replication Scenario(Sql 2000)i have one central Server (publisher)-- 250 subscribers .Merge replication was setup from central to all subcribers for all 50 tables. dbsize is around 600 megabytes.Everything was working fine. but when we added 51st table to the publisher.when the snapshot runs to sync the new table to copy the schema and data. the snapshot is recreating schema and data for all the 51 tables not just the 51st table.this is causing the data about 600 megs to be retransmitted to all the subscribers on addition of new table.How can we restrict the snapshot from recreating the whole db instead of just the newly created table .Any Suggestions.-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2003-07-24 : 23:04:13
|
| hi,I have merge repl setup in SQL 7, not 2000.But I have had the same experience. When I just want to add a new table to the repl scheme, I have always had to start all over and re-publish all the tables. Very time-consuming. There may be an easier way, but I havent found one. With 250 subscribers, wow that would be very slow.I will be interested to see if anyone replies with a better method for adding a new table.Good luck, John |
 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-26 : 22:11:50
|
| All below here is up to Merge Replication with Push type Subscriptions.So, you wish to publicate a (newly created) table:1) drop all subscriptions of the publication2) add the table as a new article to the publication. Then Repl Wizardcorrect your table (e.g. by adding the new column with RowGuid prop)and run Snapshot Agent for creating the changed publication snapshot.Quit Repl Wizard window3) using Export Wizard transfer the corrected table as an object (withall its triggers and so on (your choice)) to the future subscribing DB4) now, while re-creating the subscription, you may choose the option'No, the Subscriber already has the schema and data' in 'Initialize Subscription'step of Push Subscription Wizard- Vit |
|
|
|
|
|
|
Merge replication problem