SQL Server Replication in the Real World
A Practical Approach to Using SQL Server Replication
Ratings 4.18 / 5.00
What You Will Learn!
- You'll understand the architecture behind SQL Server replication.
- You'll be able to make decisions on which replication topology is right for any scenario your in.
- You'll be able to set up all three flavors of SQL Server Replication.
Description
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!!!
Who Should Attend!
- Anyone using SQL Server who needs to move data between two environments.
