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 |
|
jbates
Starting Member
9 Posts |
 Posted - 2002-08-01 : 15:54:54
|
| Hi SQL servers !This db has merge replication and is SQL Server 7.I have a new table that needs to be replicated. Thought I could just modify the Publication Properties--> Articles, adding this new table to those already being replicated. But apparently it is not that easy.Got a message saying I would have to drop all subscriptions first.So this is what I plan to do:- Run the db backup job- Drop the subscription- Check-off the new table name in the Articles window- Re-Create the subscription- Run the Snapshot agentDo I have all the necessary steps ?Thanks for any tips. John |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-08-05 : 07:21:03
|
| That's how i'd do it with transactional replication. Plus the synchronize step after running the snapshot.Paul |
 |
|
|
|
|
|
Need to add new table to merge-replication