Tagged Questions
1
vote
1answer
51 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
0
votes
0answers
28 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
22 views
What will happen if i change the compatibility level of Distribution Database [duplicate]
I have implemented merge replication in production environment, initially it was in SQL Server 2005, then it was upgraded in-line to SQL Server 2008 R2. Later on all databases compatibility level was ...
2
votes
0answers
52 views
Once in a while synchronization of the independently updated mysql databases problem
I have a production database and a test database running on MySQL with MyISAM and InnoDB tables, which are updated independently.
The Production database is updated by system and sometimes by a user.
...
7
votes
2answers
376 views
Merge replication fails on executing query
My merge replication was working fine this morning. Since an hour or 2 ago, my synchronisation status windows keeps showing this message:
Thread id 3108 will wait for 15 second(s) before retrying the ...
0
votes
1answer
77 views
Re-subscribing to a merge publication after edits made offline
Hypothetical Question - To help scenario planning.
Let's say I have a 2008 R2 Merge Publication with 5 active subscribers. The publication is deleted and all subscriptions are removed. A week or so ...