SQL Server Transactional and Merge Replication

Показать описание

Chapter 1: Server Environment
0:00 Setup Static IP Address (publisher)
1:00 Change Publisher's host name (publisher)
1:32 Firewall Rules (publisher)
3:11 User Account (publisher)
3:43 Edit host file (publisher)
4:30 Restart (publisher)
4:57 Setup Static IP Address (subscriber)
5:59 Change Publisher's host name (subscriber)
6:39 Edit host file (subscriber)
7:39 User Account (subscriber)
8:12 Firewall Rules (subscriber)
9:19 Restart (subscriber)
9:27 Switch user account (publisher)
9:59 Switch user account (subscriber)
10:59 SQL Server installation (publisher)
12:01 SQL Server installation (subscriber)
14:01 SQL Server configuration (publisher)
15:26 SQL Server configuration (subscriber)

Chapter 2: Database Setup
17:39 SQL Server Management Studio: Connect to publisher
18:09 SQL Server Management Studio (publisher): create source database
18:31 SQL Server Management Studio (publisher): create source table
19:46 SQL Server Management Studio: Connect to subscriber
20:01 SQL Server Management Studio (subscriber): create target database

Chapter 3: Transactional Replication
20:36 SQL Server Management Studio (publisher): create new publication (transactional publication)
22:19 SQL Server Management Studio (publisher): create new subscription
23:59 SQL Server Management Studio (publisher): test replication
24:16 SQL Server Management Studio (subscriber): table's schema has been replicated
26:08 SQL Server Management Studio (subscriber): replication monitor

Chapter 4 Merged Replication
27:00 Merged Replication
27:27 SQL Server Management Studio (publisher): new publication (merge publication)
28:40 SQL Server Management Studio (publisher): new subscription
30:21 SQL Server Management Studio (subscriber): test subscription status