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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-12 : 15:34:27
|
| vxpl writes "I am using push subscription. Distributor is at seperate machine. These are a few questions I want folks to give me some advise:1. I add a new table to the publisher database after setting up replication and the publisher and subscriber are all syn. I add this table to the publication article. How do I replicate this table to the subscriber. Do I need manully restart snapshot agent? If I start snapshot agent again, will it republish all the articles in the publication again, or just this this new table ?2. I changed the schema of a table at the publisher. This table has been published to the subscriber. How do I replicate this schema change to the subscriber ? The subscriber doesn't seem to reflect the changes at the publisher side at this moment. 3. Will push replication impact the performance of the publication machine comparing with pull subscription ? Since the distributor is at seperate machine.4. For push subscription, can I republish subscriber database to another database ?Thanks." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-17 : 06:42:11
|
| Firstly, what version of SQL Server are you using and what type of replication are you performing (transactional, merge, snapshot) ?Depending on the SQL Server version answers can vary for some of these.===========Paul |
 |
|
|
|
|
|
repl questions