Review from similar course:
“The trainer has a nice clear voice and the most important is that he does not rush through the subject, which is the problem with many instructors. By speaking slowly and displaying every step, it saves us time by not having to replay every section over and over, thanks for this.” – Andres
Welcome to SQL Server Replication in the Real World.
In this course, you’ll learn how to correctly configure the three replication topologies specific to SQL Server.
Replication is a way of distributing data automatically from a source database to one or more destination databases.
In this course, we are going to cover three core topologies.
They are, Snapshot Replication, Transactional Replication and Merge Replication.
It has also been used to for high availability solution but that’s not recommend.
Replication is for continuous data transfer and is not used for simply copying data.
The two most common real world applications for replication are reporting and data warehousing.
I’ve also seen it used for off-loading nightly batch processing tasks.
Replication uses a Magazine Publishing vocabulary. Anything from an article to an entire database can be replicated.
In the course, we are going to cover all the nomenclature, architecture and real world tips and tricks you’ll need to keep replication functioning without issue.
Thanks for your interest in SQL Server Replication in the Real World. We will see you in the course!!!