SQL

 

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