One of the three replication method in SQL server .Merge replication is typically used in server-to-client environments.
2
votes
1answer
147 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
116 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
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 ...
3
votes
0answers
60 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?
...
0
votes
0answers
174 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 ...
3
votes
1answer
116 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
90 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 ...
3
votes
1answer
83 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
453 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
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
0answers
61 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,
...
1
vote
2answers
161 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 ...
2
votes
2answers
192 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
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
1answer
95 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
0answers
38 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 ...
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 ...
3
votes
1answer
75 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
258 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
155 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
124 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 ...
