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 |
|
abdul
Starting Member
28 Posts |
 Posted - 2006-09-19 : 08:57:20
|
| I have one-way merge replication between two SQLServer. One is 2000 Personal, other is MSDE. I made the change "-ExchangeType 1" in order to make merge replication one-way. However it didn't work. Is it because of MSDE or different versions of 2000? Does anyone have an idea? Rishi this is your favourite topic, maybe you have an idea :Dabdul |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-19 : 14:44:37
|
| Abdul where did you added this para. Can you post the whole command for the merge agent where u added this new value. I am sure the parametre is not at the right place.ThanksRishi Maini |
 |
|
|
abdul
Starting Member
28 Posts |
Posted - 2006-09-20 : 02:35:56
|
| Well, it worked. All sql server needs is a stop/start to make changes work. |
|
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-21 : 03:49:30
|
| Stop and re-start of the SQL or just the merge agent ? I should be just re-start of the Merge agent.ThanksRishi Maini |
|
|
|
abdul
Starting Member
28 Posts |
Posted - 2006-09-21 : 05:01:38
|
| This is not a big deal but I experienced that start/stop of sql/server is needed. |
|
|
|
abdul
Starting Member
28 Posts |
Posted - 2006-09-22 : 06:43:28
|
| Actually it could be a big deal occasionally. If you do not want to stop server than it's a problem. Considering this case I again changed a former two-way replication into type 1. Without stopping server, stop/start of merge agent worked. So if you want to change direction of a replication without a start/stop of whole server just restart the merge agent. |
|
|
|
|
|
|
one-way merge replication