January 11, 2008 at 12:26 pm
Hi guys,
Lets say i have already configured my articles(eg. 200 objects) for publication and the ran snapshot agent. If in the future i wanted to add a few more article to the publishing list and re-run the snapshot agent will it copy articles i previously added to the list?
thanks pple
January 12, 2008 at 9:38 am
Im not fully sure what you mean by "copy" but it will take a snapshot of any table, view etc in that publication and place it in the snapshot folder. This will not be applied to the subscribers unless you reinitialise the subscriptions. You can however just create a new publication with your new tables and run the snapshot agent and then apply the snapshot, this would leave your origional publication untouched
January 12, 2008 at 6:04 pm
"This will not be applied to the subscribers unless you reinitialise the subscriptions"
I find the above not to be true, if the distribution agent is continuosly running everything should be applied to the subscriber (i tested this using transactional replication).
I actually want to just find a way of applying new articles to existing subscriptions without having the process of creating new snapshots bulk copying all existing articles, as this will take too much time.
>>>>>I'm using transactional replication
January 14, 2008 at 3:41 am
Hi Denby,
I have just run a test on my machine and will go through what i did and what i saw. Its all done on one server replicating from adventureWorks to a new db i created called AD_Repl
I published one table dbo.AWBuildVersion as a transactional replication (not updateable subscribers) and set the snapshot to run immediately. I setup a subscriber (push) to run continuously and initialise immediately.
Looking in replication monitor i could see the snapshot run (1 sec) then on the log for the subscriber i could see the snapshot being applied and the 1 row copied across.
I then deleted the row for AW_Repl and reran the snapshot, this didnt apply the snapshot to AW_Repl until i went to reinitialise in SSMS and ticked use current snapshot. It then copied across the 1 row again.
I deleted the row again from AD_Repl and added another table to my publication Production.BillOfMaterials. I then ran the snapshot (3 secs) and in the log of the subscriber i could see the rows copied into Production.BillOfMaterials only. Running a quick select showed i had 0 rows in dbo.AWBuildVersion and 2679 rows in Production.BillOfMaterials.
I then went to reinitialise again using the current snapshot and checked the log. I could see the rows for both tables being bulk inserted. Doing the select again i had 1 row in dbo.AWBuildVersion and 2679 in Production.BillOfMaterials.
Maybe you could try the same and see if we get the same results?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply