One of the three replication method in SQL server .Merge replication is typically used in server-to-client environments.
0
votes
3answers
138 views
Merge Replication identity field issues
One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
0
votes
2answers
25 views
How to properly clean Merge Replication Setup
What is the proper way to completely clean Merge Replication setup ?
I have tried to delete the subscriptions, then delete the publication then "Disable Publishing & Distribution" & delete ...
7
votes
1answer
217 views
Hard limitation for merge replication article count?
A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
1
vote
1answer
77 views
SQL Server replication conflicts after migration from 2000 to 2008
I got a suggestion over at Stackoverflow to post here....greatful for any and all help.
Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
0
votes
1answer
86 views
SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers
We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
0
votes
1answer
41 views
Syncronize mysql databases between local and hosted servers automatically
We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
178 views
How to troubleshoot SQL Server Merge Replication Conflict?
I have SQL Server 2008 R2 Merge Replication setup.
I have 2 publications for the same database with 20+ subscribers.
The logic of our application prevents changing the same data from 2 subscribers ...
3
votes
0answers
111 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
3
votes
0answers
91 views
Uninitialized Merge replication subscription
I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the ...
3
votes
0answers
73 views
Multiple Merge Replications on same SQL Server Database Conflicts
I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...
3
votes
0answers
159 views
SQL Server 2008 R2 - Merge Replication - Can the Distribution Database size cause replication problems?
Setup:
We have a SQL Server 2008 R2 instance running on a central server.
The server is a merge-replication publisher.
We have 'N' subsribers running SQL Server 2008 Express. 'N' can grow to any ...
3
votes
0answers
63 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
2
votes
0answers
52 views
merge replication too big
I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database.
for some reasons I keep the old data in the databse and set ...
2
votes
0answers
54 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
2
votes
0answers
49 views
How To Diagnose Slow sp_mssetupbelongs
I am using merge replication with SQL 2012.
When performing a clean sync using the merge agent I am getting a timeout on this stored procedure,
sp_mssetupbelongs
I am wondering what the best way to ...
2
votes
0answers
45 views
MSMerge_contents Table Populated After One Sync
I am running merge replication with SQL 2012.
When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF.
When I run ...
2
votes
0answers
69 views
Identifying connection and publisher vs subscriber in merge replication scheme
We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
2
votes
0answers
56 views
Merge Replication Optimization
I am running Merge Replication on Microsoft SQL Server 2012 through web sync.
Is there a way to recognize when regenerating a new snapshot and applying it would be more efficient than running a ...
2
votes
0answers
135 views
How to Rename Table or Field With Merge Replication
I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field.
These operations are not permitted in merge replication.
However I can think of an ...
1
vote
0answers
55 views
How To Use Publication Without Precompiled Partitions
I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work.
The merge agent is slow to do ...
1
vote
0answers
91 views
Dropping One Computed Column Causes All Computed Columns To No Longer Replicate
We recently dropped a computed column from a table that was participating in merge replication. After issuing the statement the other two computed columns remained in the table but stopped ...
1
vote
0answers
51 views
How to Remove Articles Based on User
I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks.
I have a filtering scheme that controls which tables end up ...
1
vote
0answers
20 views
How to tell what user has synced
I have set up merge replication web sync to sync a publication from a SQL 2012 database.
I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME().
When I do a sync is it ...
0
votes
0answers
16 views
How to delete orphaned records from sysmergesubscriptions table?
I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table.
Each time I delete unnecessary records, it show up again after it syncs with any ...
0
votes
0answers
39 views
Merge Replication Finding Session Id
I am using merge replication with SQL 2012.
I am writing a custom business logic handler, and would like to know if there is a way to get a session id?
For instance if the custom business logic ...
0
votes
0answers
80 views
How to user the Tablediff Utility with Replication Filters
I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence.
I see a problem with this approach though. This is because I am using parameterised filters to ...
0
votes
0answers
181 views
How To Speed up Merge Replication
I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM.
The replication process works quite well, but it is when it comes to applying the ...
0
votes
0answers
63 views
Can a Merge Filter Have Multiple Parent Tables?
I am using merge replication in SQL 2012. I have a situation where I am using join filters to filter out what records are being replicated to the subscriber.
When I look at the stored procedure,
...
0
votes
0answers
81 views
How to Fix Merge Replication Error
I am using merge replication with SQL server 2012. I have set up a subscription and publication and everything was working.
I now get this error message,
Cannot have a dynamic snapshot job with both ...
