[Udemy] Mastering SQL Server Replication Free Download

Learn SQL Server Replication Step by Step

New

(4 ratings)

1,304 students

Created by Syed Kareem

Last updated 2/2021

What you’ll learn

SQL Server Replication

Requirements

Knowledge of SQL Server

Description

SQL Server Replication is one of a object level high availability feature which allows to replication or synchronize data across the databases. We have both options to synchronize data in one-way or bi-directional way.

We can implement master/slave or multi-master replication scenarios with SQL Server.

SQL Server supports both homogeneous and heterogeneous replication options i.e. we can replicate changes between SQL Server to SQL Server instances as well as SQL Server to Oracle/Sybase any other RDBMS products. Even we can make Oracle as Publisher and SQL Server as subscriber.

Unlike Log Shipping and Database Mirroring SQL Server Replication allows to maintain some part of the database or required objects in different servers.

We can synchronize data between same domain servers or different domain servers.

This course is designed to master SQL Server Replication technology. Course is designed to target beginners as well as advanced SQL Server professionals.

This course describes complete Replication features including introduction to High Availability features in SQL Server, introduction to Replication feature, replication entities, types of subscriptions, architecture, Types of replication options like Snapshot Replication, Transactional Replication, Merge Replication and Peer to Peer Replication, monitoring and Troubleshooting common issues in replication.

You will learn complete replication features step by step with 100% practical oriented. So start learning now….!