From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Database replication

Database replication - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Database replication

“

- [Instructor] In this video, we'll discuss the purpose of database replication and show you how you can accomplish it in SQL Server. So what is replication? Well, essentially, it's a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between those databases to help maintain consistency of the data. Using replication, you can distribute data to different locations and even to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, or even the internet. There are three basic types of replication. The first is transactional replication, and this is typically used in a server to server scenario that requires high throughput, including improving scalability and availability, and is potentially used for data warehousing and reporting scenarios as well. It's great for integrating data from multiple sites or integrating heterogeneous data and offloading batch processing…

Contents