All Questions
Tagged with transactional-replication merge-replication
11 questions
0
votes
1
answer
219
views
SQL Server replication model snapshot, transactional and merge - which is best [closed]
I am trying to implement sql server database replication between 2 branch servers to a Head Office Server.
My application is a distributed one, the main application is hosted on head office which is ...
- 125
1
vote
1
answer
252
views
SQL Server replication with subscriber doesn't know about the publisher
I have a case where many sql server instances need to be merged and centralized in one master database.
This needs to be near real-time solution. After looking around in google, I've found that ...
- 1,829
1
vote
1
answer
962
views
Partitioned table in publication and a non-partitioned table at subscriber in Sql Replication
I was wondering whether we can use partitioned tables at the Publication level
and non-partitioned tables at the Subscriber level? I was reading this article,
Replicating Partitioned Tables and ...
- 192
0
votes
1
answer
168
views
Where can I see the @published_in_tran_pub property?
We have a merge replication that sources on a subscription of a transactional replication. According to this source (Multiple SQL replication types) I need to set the @published_in_tran_pub to true.
...
- 111
0
votes
1
answer
347
views
Is a Transactional Replication Snapshot processed as a 'bulk insert'
I have a Merge replication that sources on a subscription from a Transactional Replication. I know that the triggers regarding the Merge replication are not fired by 'bulk inserts':
Microsoft: ...
- 111
4
votes
1
answer
1k
views
Replicate a filtered subset of data: Merge or Transactional replication?
First of all thanks for reading.
I need to replicate a subset of data that is based on a join filter; filter based on a join with an other table (Microsoft:"Using join filters, you can extend a row ...
- 111
3
votes
1
answer
217
views
Merge Replication not receiving updates via Transaction Replication when republishing
I'm trying to migrate from server Z, which replicates out to a dozen subscribers in two data center, to servers A & B, one in each data center. In order to survive outages between data centers we ...
- 1,336
0
votes
1
answer
4k
views
SQL replication, merge publication, cannot connect to subscriber
i have some difficulty in setting up SQL replication over the internet.
I am using a static public IP thru my firewall and port forward to the distribution server.
basically everything is fine, i was ...
- 165
1
vote
1
answer
971
views
SQL server transactional replication, change distribution server
I have a SQL 2005 database which is published with dozens of (mostly) transactional publications and dozens of subscribers . Currently we have a local distributor. I'm trying to improve our HA for ...
0
votes
0
answers
96
views
AS400 subscription to SQL Server 2008 R2 Std
I am aware that you can create a subscription on an AS400 box to a SQL Server box. My question is, can you have replication if you do not have active journals going on some of the AS400 tables?
4
votes
2
answers
563
views
What's the solution for bidirectional Replication type on vertical filtered table(some of columns) in SQL Server 2008
Assume we have a table in two database instance like following:
CREATE TABLE StudentList
(
StudentId int NOT NULL PRIMARY KEY,
StudentName nvarchar(255) NOT NULL,
StudentGrade int
)
...
- 1,437