Stack Overflow
Stack Overflow

Questions tagged [merge-replication]

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.

Merge replication starts with a snapshot of the publication database objects and data. Subsequent data changes and schema modifications made at the Publisher and Subscribers are tracked with triggers. The Subscriber synchronizes with the Publisher when connected to the network and exchanges all rows that have changed between the Publisher and Subscriber since the last time synchronization occurred.

More information: Merge Replication.

264 questions
0
votes
2 answers

SQL Merge Replication between SQL Server 2012 and SQL Server CE, 3.5, sp2

Receiving "OpenDB failed getting pub version 28627" in SQLCESALOG.txt when trying to create a subscription on SQL Server CE 3.5 sp2. server1 is running Win 2008, IIS 7.0, SQL Server CE 3.5 sp2, Replication tools, client tools. This server also…
Progger
  • 2,266
  • 4
  • 27
  • 51
0
votes
1 answer

Replication Custom resolver changes empty strings to NULLs

We have an C# application which posts to a database which is replicated to another database (using merge-replication) and has one custom resolver which is a stored procedure. This was working fine under SQL Server 2000 , but when testing under SQL…
sgmoore
  • 15,694
  • 5
  • 43
  • 67
0
votes
0 answers

SQL Server Replication agent security settings error

When I try to change the account for the snapshot agent in a merge replication publication I am getting this error: Cannot save changes to agent security settings. An exception occurred while executing a Transact-SQL statement or batch. …
johnmcp
  • 891
  • 1
  • 10
  • 17
0
votes
1 answer

merge pull subscription Output path change (Sql Express 2008R2)

I have a single merge replication with pull subscribers (Sql Express 2008R2) and Sql Server 2008R2 as publisher. I want to turn logging on for specific subscribers only for occasional debugging. SSMS on subscriber machines is not an option. I know I…
Brian
  • 1,337
  • 5
  • 17
  • 34
0
votes
1 answer

Can I/should I script system tables for merge replication in SQL Server

I have just started a new job as the only developer on a system. To start with I wanted to set up a development system that is the same as the live system, but without any data. Then I want to populate it with test data. So the first thing I did was…
Colin
  • 22,328
  • 17
  • 103
  • 197
0
votes
1 answer

SQL replication to SQL Compact 3.5 via FTP?

I'm trying replicate a SQL Server database to a device with SQL Compact 3.5 on it and I can get replication working fine via IIS. However, the publication has an option to use FTP to publish the replication data, but I don't seem to be able to…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
0
votes
1 answer

Trigger does not work because of deprecated datatype in replicated table

I have a table in my SQL Server 2005 database, which has a field with the datatype NTEXT. This table is replicated in a merge-replication with a lot of SQLCE-subscriptions. I have tried to add an ON INSERT trigger to this table to process the…
abc
  • 2,285
  • 5
  • 29
  • 64
0
votes
1 answer

Sync creating multiple subscription sqlcereplication

I am currently developing a bridge between a database and a sql server database android (sqlite). To do this, I use a web service and filtered replications with sqlce databases stored on a server IIS 7. To develop this, I used IIS Express on my pc.…
RBische
  • 116
  • 3
  • 9
0
votes
1 answer

An error stopped replication agent from running

'm running a merge replication between two databases everything was fine. Starting from yesterday i'm getting this error message from replication job at Run Job step : Executed as user: NT AUTHORITY\SYSTEM. String or binary data would be truncated.…
HichemSeeSharp
  • 3,240
  • 2
  • 22
  • 44
0
votes
1 answer

Application crashes with error in filesys.exe

If have an application (let's call it A, CF 3.5) which calls another application (B, CF 3.5 as well) within the same directory to delegate some work (downloading a file). This works well, as long as the SQL Server CE assemblies (3.5 SP2) are not…
Gene
  • 4,192
  • 5
  • 32
  • 56
0
votes
0 answers

sql server compact db manual merge

I have a mobile db (SQL Server CE), which synchronizes with my database on a SQL-server via merge replication. after some trobules with the device, I had to copy the mobile db from the device, but i couldn't sync anymore before that. There are some…
abc
  • 2,285
  • 5
  • 29
  • 64
0
votes
1 answer

Create subscription for Merge Replication

I have 2 server (Server1, Server2). I want to run a script to make Server2, the subscriber of Server1. It's very simple using wizard. I have generated related script using wizard but it doesn't work. The script is: EXEC sp_addmergesubscription …
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
0
votes
1 answer

How to Use an Int ID in merge replication

I am going to be using merge replication in SQL 2012 for offline clients who can synchronise their data. The merge replication process adds a guid to each table that is being replicated, but I am wanting to know how to add an additional int id as…
peter
  • 13,009
  • 22
  • 82
  • 142
0
votes
0 answers

SqlCeReplication with client certificates

We have a lot of devices which synchronize their databases using the SQL CE Merge Replication (over SSL and with Basic Authentication configured). Now we want our clients to additionally identify themselves with a client certificate, but we're…
Gene
  • 4,192
  • 5
  • 32
  • 56
0
votes
1 answer

Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication

I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on…
Thakur
  • 1,890
  • 5
  • 23
  • 33
1 2 3
…
17
18