January 17, 2013 at 1:35 pm
I'm currently working on snapshot replication with SQL server 2008 R2.
I've been able to create the snapshot and the subscriber is able to start pulling down the snapshot without any issues. The problem i'm running into is there are some Stored Procedures that the replication services is not liking and is throwing out errors and stopping the replication process.
Is there a way with replication to say "continue replication with errors". The destination database is just going to be used for reporting purposes and they aren't concerned about the errors.
January 17, 2013 at 6:48 pm
Do you need the procedures replicated as well or just the data in the tables?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 4:43 am
You can switch off schema replication?
January 18, 2013 at 5:56 am
Stupeo (1/18/2013)
You can switch off schema replication?
Yes, there's an option to set the Replicate Schema Changes to false but this means every time a column is added/changed your replication will break and you'll have to reinitialize. IMHO, keep this option set to true...
When setting up the publication I would un-check the stored-procedures "objects to publish" and just choose tables. Once the snapshot has completed successfully, I would then recommend scripting out the procedures and applying them to the subscriber
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply