What are the prerequisites for Replication in SQL Server?
Pre-requisites At least one database should have an article and must possess Primary Key; a basic rule that every article should have a Primary Key is considered as best candidate for Transactional SQL Replication. The primary key is used to maintain uniqueness of records.
What types of Replication are supported in SQL Server?
There are four MS SQL Server replication types: snapshot replication, transactional replication, peer-to-peer replication and merge replication.
- Snapshot replication.
- Transactional replication.
- Peer-to-peer replication.
- Merge replication.
- Configuring users for MS SQL Server.
- Importing a database from a backup.
What do I need to know about SQL server replication?
Sometimes, I just want to see the publication name and subscriber server names (no articles) to see what servers are being used with replication other times I want all of the information, so I added a variable called @Detail and if you set @Detail = ‘Y’ it will return data with the article list.
Where do I query for Merge Replication articles?
Note, that sysmergepublications and sysmergearticles tables are queried in the Publisher DB because MSpublications and MSarticles tables in distribution DB mentioned in other answers in my case with SQL Server 2008 R2 had no records for merge replication articles.
Where are replication tables in the subscription database?
Scroll down to the section for “Replication Tables in the Subscription Database” and you will find the tables for publications, subscriptions, schemas, articles and columns. For those needing a quick snippet…
Where to view and modify Article properties in SQL Server?
View and modify article properties in the Publication Properties – dialog box, which is available in Microsoft SQL Server Management Studio and Replication Monitor. For information about starting Replication Monitor, see Start the Replication Monitor.