New Microsoft SQL Server Video Tutorial: Pt. 2 - Setting Up Publications for Transactional Replication

Pt. 2 - Setting Up Publications for Transactional Replication - view details

This video, part 2 in our series, walks you through creating publications using the "Create Publication Wizard" in SQL Server Enterprise Manager. You'll learn about publishing tables and doing vertical as well as horizontal filters.

Highlights from this video:

• What requirements are there for publishing tables?
• How to publish an entire table and how to publish only certain columns
• How to publish all columns but only rows that meet a WHERE clause
• Should you change the destination object owner?
• Syntax for writing filters
• Determining snapshot creation and snapshot agent location/properties
• How frequently should the snapshot agent run?
• Scripting your publication for easier maintenance/reinitialization
• After running the wizard, how to modify and view the publication's properties
• How to generate new snapshots
• What does the snapshot look like? How is it implemented?

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Replication in SQL Server
• Skill Level: 200 (Beginner - Intermediate)
• Length: 16:10 (10.4MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizont