SQL Server DBA Tutorial 103-How to Create Merge Replication in SQL Server

preview_player
Показать описание
In this video you will learn how to create Merge replication in SQL Server using SQL Server management studio as well as using T-SQL script. You will also learn how to configure the publication for Merge replication, best practices of configuring publications for Merge replication, how to add database and it's articles in Merge replication, configuring Publication agent security and best practices of security configuration of Publisher as well as Subscriber.
It also demonstrates consideration while creating Merge Replication, walk through article, publisher and distributor properties.

Blog post link for the video:

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

Hi, i did merge replication one way from Publisher to Sybscriber.But when i inserta record, a new rowguid is generated in the subscriber.Why is it so?

josejojan
Автор

in the last step i deleted the merge replication to test it out .. then opened the file which i had saved during publishing. that went through

but in the secondary server. the subscription file didn't come .
so i tried running the new file for subscription in the secondary server. it said subscription already exists. ??

ggneply
Автор

It's working fine while I am using only tables but with stored procedure I am getting sp_hexadecimal error.. how to fix it

bhuvanesh
Автор

Greetings.
To that publication, can I add as many subscribers as I want?

I have 8 servers and I have tried to replicate from a Master, but when I add a new subscriber and start synchronizing, after a few minutes it tells me that "The merge process could not replicate one or more INSERT statements" that I checked in the SQLProfile and That solves the problem.
What could be happening? Will I have found something wrong?
I look for the processes and delete the ones that run the synchronization and then restart the SQL Server agent and start the process again, but after a few minutes the same problem happens.
Any idea what I could have done wrong?
Beforehand thank you very much!

macruzgi
Автор

can client(subscriber) database sync with each other in absence of server(publisher)

karangoyanka
Автор

Hi,
I have a scenario where I have configured SQL Server local on a tablet and save some data temporarily to that local db. As soon as there is internet available the data saved offline gets synchronized to the main SQL Server. Can I use the subscriber and publisher concept here i.e merge replication?

kinjalpandya
Автор

did you merge the files for publication and subscritipon

ggneply
Автор

Any help guys? The table from sql mirror server doesn't show up the table that must be replicated

jordanmendoza
Автор

I want to update and migrate database from SQL Server 2014 to SQL Server 2019 so that if there is any failure at SQL Server 2019 I will come back at SQL Server 2014 and get all the transactions back at SQL Server 2014 which held at SQL Server 2019.

Although I thought about merge replication. But want to know if the SQL Server 2019 fails so in this case will merge replications process occur. Will I get data of SQL Server 2019 in SQL Server 2014.

Please suggest a possible solution.

shrutisrivastava