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
1
vote
1 answer

Merge and Trigger - Primary Key Violation

I have those tables CREATE TABLE [Test]( [Id] [int] NOT NULL, [Value] [int] NOT NULL, [Id_Test_2] [int] NOT NULL, CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,…
Luigi Saggese
  • 5,299
  • 3
  • 43
  • 94
1
vote
3 answers

SQL Server merge replication error "The schema script 'xxx.sch' could not be propagated to the subscriber"

I recently made some changes to a working publication under Merge replication which seem to have broken synchronization for the subscriber. The error message I'm getting is: The schema script 'ftdb_arcmessagefac64b65_76.sch' could not be…
Loftx
  • 1,760
  • 4
  • 29
  • 50
1
vote
2 answers

Merge replication - publisher missing data from subscriber

I have a database using SQL 2005 merge replication and ther has been data inserted into the subscriber that never went over to the publisher. I believe there was a conlict that happened over the 14 day retention period ago and I do not see it any…
user142253
  • 494
  • 1
  • 6
  • 16
1
vote
1 answer

Replication Warning: To allow replication of FILESTREAM data

I executed a line of script exec sp_addmergearticle @publication = ... and got this warning Warning: To allow replication of FILESTREAM data to perform optimally and reduce memory utilization, the 'stream_blob_columns' property has been…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
1
vote
2 answers

Does it matter if time goes out of sync on merge replication clients?

I'm quite new on merge replication, but a scenario. If I have a server, and two clients with pull subscriptions does it matter if the time on those machines goes out of sync with each other or the server? When I modify some data on one of those…
peter
  • 13,009
  • 22
  • 82
  • 142
1
vote
2 answers

Loop through a table and assign foreign key to new record if null

I am working on an SQL Database I have a Table Users Id Name Age AddressId ----+------+------+----------- Where AddressId is a foreign key to a table names Addresses The Addresses Table: Id Country State City …
Y2theZ
  • 10,162
  • 38
  • 131
  • 200
1
vote
1 answer

how to merge rows in datatable which had same value (VB)

I have one datatable tempDT with value : Serial_No testong --------------------------------------- DTSHCSN001205035919201 [ OUT ]
Partner : 90000032
Date : 16 Feb 2012 DTSHCSN001205035919201 [ IN ]…
tyo
  • 67
  • 1
  • 2
  • 13
1
vote
0 answers

Merge Replication on not all of columns

I want to configure a merge replication between two table which are have a special column with different values. It means the replication shouldn't synchronize the special column. I configured this replication (push mode) but when i configured the…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
0
votes
1 answer

Get last replication date/time from SQL server CE

I have a Windows Mobile 6.0 application with SQL Server CE 3.5 on the device. The program gets the latest data from the publisher - SQL Server 2008. The replication is working fine but I want to display to the user the last time it replicated from…
hydev
  • 744
  • 1
  • 10
  • 30
0
votes
1 answer

Apply database schema changes without downtime

I'm not an expert in replication for ms sql. For our project we need to upgrade database from time to time without downtime. Is there some kind of clustering/replication for such kind of needs. E.g. we need to add some tables to database or even…
snayko
  • 91
  • 1
  • 5
0
votes
1 answer

Copying a subscribed database to the publisher server

I have two servers. I have installed a merge replication in the publisher (Server A) and I have added two subscriptions with the same database name. - One on the publisher itself and the seconde one on the subscriber (Server B).So far so good. The…
HichemSeeSharp
  • 3,240
  • 2
  • 22
  • 44
0
votes
2 answers

Requirements for IIS server used for web sync, merge replicaiton

Short question: Can anyone tell me what the requirements (especially when it comes to SQL components) are for the web server used as web sync for merge replication? Background: I have a solution which uses merge replication to do one-way data sync…
Christian Rygg
  • 671
  • 12
  • 26
0
votes
1 answer

Allowing individual columns not to be tracked in Merge Replication

Using Merge Replication, I have a table that for the most part is synchronized normally. However, the table contains one column is used to store temporary, client-side data which is only meaningfully edited and used on the client, and which I don't…
user1228457
  • 99
  • 1
  • 5
0
votes
1 answer

Are there advantages to only use stored procedures to access a database with merge replication?

I have a project where SPs are the only way that the application uses to access or modify the Sql Server 2008 DB. I have developers asking to abandon the SP only approach and let them use Linq to Sql on the DB directly. I have to decide if to allow…
Durden81
  • 966
  • 9
  • 25
0
votes
1 answer

central subscriber replication in Sql Server 2008 R2

We have regional office and some data in this office.We want to transfer data from each regional office everyday to central office .For this reason I need central subscriber topology.I implement central subscriber transactional replication but I…
Shayan
  • 402
  • 1
  • 4
  • 18
1 2 3
…
17 18