Tagged Questions

1
vote
1answer
65 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 ...
2
votes
0answers
51 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 ...
3
votes
0answers
98 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
1answer
85 views

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber.

When syncing a SQL Server 2008 subscriber with a publisher, the sync fails at around 98% with this error message: The Merge Agent failed because the schema of the article at the Publisher does not ...
2
votes
1answer
175 views

Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber

is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
1
vote
1answer
36 views

Merge Replicate, reinitialise with a different part of the data

I have a set of database with merge replicate configured between them. The publisher is an aggregate of three sets of data. Call them set 0, 1, and 2 There are subscribers that grab one set of the ...
2
votes
0answers
65 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
1answer
224 views

Merge Replication: Where are rowguids of conflict losers stored?

I'm trying to obtain the row guid of all the merge replication conflict losers listed in my conflict viewer. The bug that was allowing the conflicts to occur has been identified and resolved but now ...
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 ...
7
votes
0answers
194 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
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 ...
3
votes
0answers
59 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
2answers
158 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
1answer
74 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 ...
3
votes
1answer
123 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 ...