One of the three replication method in SQL server .Merge replication is typically used in server-to-client environments.
1
vote
1answer
75 views
Minimising downtime implementing merge replication on live system
Background
We have three Servers running SQL Server 2008 which all contain a Product database. These are currently kept in sync once per day by sending a copy of the MDF to the two Subscribing ...
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
87 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
1answer
351 views
Merge replication - can't create snapshot – timeout
I have a SQL Server 2008 database, and I need a merge replication because I want to sync with mobile devices afterwards.
So I created a replication but when it comes to start the snapshot agent, the ...
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
19 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
1answer
94 views
Can You Replicate Sequences
In SQL 2012 can you replicate sequence objects, and if so do changes to the sequence (including consumption of values) get replicated?
If not is there a good reason why this was not included?
0
votes
1answer
72 views
Advise On SQL Server Data Replication
We have a huge enterprise system, with geographically seperated SQL servers.
We have some requirements related with data replication between these servers.
We have considered the Sync Framework ...
0
votes
1answer
159 views
Does The Stored Procedure sp_removedbreplication Remove Rowguids
In merge replication if I run sp_removedbreplication will that remove rowguids or not?
Will it take into account the preserve_rowguidcol values in the sysmergearticles table?
0
votes
1answer
52 views
How to understand what Columns Have Changed in Merge Replication
I am using merge replication in SQL 2012. Some of my merge articles use column level tracking.
I am trying to understand how to use the 'lineage', and 'colv1' fields in the MSmerge_contents table to ...
0
votes
1answer
174 views
Merge Replication Subquery Filters
I am using merge replication with SQL 2012. I have a number of articles in my publication and will have to come up with quite an elaborate set of filters.
If I add a filter on my article it can ...
0
votes
1answer
46 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
36 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
3answers
122 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
1answer
99 views
SQL Server merge replication across domains
I'm getting the following message when trying to set up merge replication on SQL Server 2008 R2:
The Merge Agent failed to locate the partitioned snapshot for this
subscription in the expected ...
0
votes
1answer
149 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 ...
0
votes
0answers
37 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
77 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
173 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
60 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
78 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 ...
0
votes
0answers
37 views
Subscribing to Subsets of Data in Merge Replication
I am replacing a custom sychronisation system with merge replication.
The current system on the server side allows you to select what data a client can sync to their device and edit, i.e. they will ...
0
votes
0answers
24 views
How to merge data in database [closed]
Say I have 2 businesses
ID Tittle Longitude Latitude
starbucks-coffee Starbucks Coffee 106, 6
starbucks-buckx Starbucx Coffee 106, 6
Many other table points to these 2 rows
Say I want to merge ...
