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 |
|
Hansje
Starting Member
3 Posts |
 Posted - 2004-01-12 : 11:03:48
|
| So I have set up a transactional replication from a Northwind db to a copy: Nw1. I play around with the table Categories. At 1 point I add a row to the Subscriber. Now I wish to validate the publication, and I expect to find a difference in Categories.First I run the script:use northwindexec sp_publication_validation 'Northwind_p2'goI find, among othres, this message:Generated expected rowcount value of 9 for Categories.Funny. I added an extra record in the subscriber...Now I use the option Validate Subscriptions when clicking RM on the Publication in EM. Now I see the message:Table categories maybe out of synch. Rowcounts(actual count:10, expected:9)This last message is correct. I THOUGHT the sp would yield the same result as the pop-up option, this seems not to be the case.Is this correct? Do I miss here something, or have I done something wrong?Tnx,Hans Brouwer |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-12 : 12:33:43
|
| If you added the record at the subscriber, then the publisher is not going to get it with transactional replication. Transactions get replicated from the publisher to the subscriber and not the other way around. Have you looked into two-way replication or merge replication?Tara |
 |
|
|
Hansje
Starting Member
3 Posts |
Posted - 2004-01-13 : 06:47:48
|
| Tnx for the response, Tara. My problem has not to do with whether the is good or false. My problem is, that when using the EM functionality to validate the replication I get a different outcome then when I use the stored procedure. I made the extra record in the subscriber deliberately just to check on an errorsituation. When using the EM functionality, the expected outcome is there...Tnx anyway,Hans Brouwer |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-01-13 : 08:50:30
|
| but did you not do 2 different things...1st...you did...exec sp_publication_validation 'Northwind_p2'...which was the publisher2nd...you did...Validate Subscriptions in EM....So are you not comparing 2 different objects/results? |
|
|
|
Hansje
Starting Member
3 Posts |
Posted - 2004-01-13 : 09:17:16
|
| Tnx for your response, Andrew.I don't think I did 2 different things, unless I completely misunderstand the use and purpose of sp_publication_validation.If I look in BOL under Validating Replicated Data I am given 2 options to do this: either with EM functionality or with this stored procedure.There is only 1 subscription in this case, Northwind_P2. I used it as parameter in the execution of the stored procedure. Next I right-clicked on the publisher in EM and choose the option Validate Subscriptions. I am under the impression, that both actions should accomplish the same thing. Maybe I am wrong, but then: why? And what IS the purpose of sp_publication_validation?Tnx again,Hans Brouwer |
|
|
|
|
|
|
|
|
Validation: 2 ways, 2 outcomes?