A type of replication in SQL Server in which Publishers and Subscribers can work autonomously and later reconnect, synchronize, and merge data changes to achieve convergence among all nodes in the topology. Merge replication is typically used in server-to-client environments.

learn more… | top users | synonyms

1
vote
1answer
444 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 ...
2
votes
1answer
57 views

What else does sp_addmergefilter do

I am running the following stored procedure to add a merge replication join filter, sp_addmergefilter What else does that stored procedure do behind the scenes? I am calling that stored procedure ...
1
vote
1answer
308 views

SQL Server Merge Replication, Agent Batch Size

Is there anyway to increase the merge agent batch size after the publication is created? I know DownloadGenerationsPerBatch flag when creating a new Publication, however what I'm looking for is a way ...
2
votes
1answer
326 views

Why would “Drop Database” fail on local SQL Server 2005 Express instance?

I am trying to run the below code. It works for me but not for at least some of my users it doesn't work. It doesn't seem to error just no actually remove the DB's. string sqlConnectionString=@"Data ...
1
vote
1answer
241 views

Why Regenerate Snapshots For Merge Replication

I am in the process of implementing merge replication in SQL 2012 with web sync. I am wondering two things, Why is it suggested to regenerate the snapshots every 14 days by default? With web sync ...
1
vote
1answer
667 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 ...
2
votes
0answers
61 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 ...
3
votes
0answers
83 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? ...
1
vote
0answers
325 views

How To Speed up Merge Replication [closed]

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 ...
3
votes
1answer
151 views

Merge replication with PDAs AND P2P replication between servers?

We're currently building a setup to scan tickets at an event. We plan on having 2 servers at each entrance but can't have a local link between the two. We have scanners (sqlCE) and half of them are ...
1
vote
1answer
242 views

Merge Replication Snapshot Files

I am using Merge Replication with SQL 2012. I look in the snapshot directory, but the largest file in there is a prc file which is 646 KB. I know for sure that the biggest of my replicated tables is ...
4
votes
1answer
120 views

Is there a way to start a script on the publisher when synchronization starts?

I am using merge replication with pull subscriptions and Web Sync. What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process? ...
6
votes
2answers
987 views

Working Around Filtering Problems in Merge Replication

I am in the process of defining filters on a merge replication publication for our database. The problem I am coming up against is that merge replication has these rules, I don't like to call them ...
0
votes
2answers
455 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 ...
1
vote
2answers
401 views

Merge Replicate and Mirrors

I am preparing some scripts to setup merge replication in our production environment. After completing the export from UAT, I've come across something that doesn't appear like it would work in the ...
3
votes
2answers
365 views

Replicating a Table Structure With no Data Using Merge Replication

I am using merge replication with SQL 2012. I have a table, and it would be useful to propogate that table to the subscribers, but just the table structure, not the actual data. The data in the ...
0
votes
1answer
315 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?
1
vote
1answer
109 views

How to tell what user has synced

I have set up merge replication web sync to sync a publication from a SQL Server 2012 database. I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME(). When I do a sync is ...
3
votes
1answer
134 views

How to update conflict resolver when upgrading from SQL-Server 2005 to SQL-Server 2008

We have recently upgraded from SQL Server 2005 to SQL Server 2008 (R2, SP1). This upgrade included some publications, where all tables are published with a default conflict resolver based on the ...
2
votes
2answers
531 views

How To Set Up Web Synchronisation With IIS 7.5

I set up merge replication web sync using a pull subscription. When I try to start the merge agent at the client side I get this error, The Merge Agent could not connect to the URL ...
2
votes
1answer
423 views

How does merge replication work with SQL Server CE

I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE? For instance merge replication with SQL Server databases ...
3
votes
1answer
295 views

Transactional versus Merge Replication (Restore backup after downtime)

I have the following transactional replication setup: Windows Server 2008 with SQL Server 2008 Enterprise Server A: Master, has a database with a table, publisher Server B: Slave, subscriber ...