RSS
Select Language


Course SQL Server 2008 Replication


Duration (days): 3
Price (CZK): 12000

SQL Server 2008 Replication topics:


Replication Basics

  • Publisher-Subscriber Model
  • Components of Replication
  • Physical Replication Models
  • Installing and Configuring Replication

Types of Replication

  • Snapshot Replication
  • Transactional Replication
  • Merge Replication

Configuring Snapshot Replication Using the GUI

  • Configuring Publication
  • Configuring a Subscription

Configuring Snapshot Replication Using T-SQL

  • Dropping Subscriptions and Publications
  • Configuring a Publication Using T-SQL
  • Configuring a Subscription Using T-SQL
  • Snapshot Replication Stored Procedures

Snapshot Generation

  • Locating the Snapshot Folder
  • Securing Snapshot Data
  • Transmitting and Storing Snapshots

Transparent Data Replication

  • What Is TDE?
  • Using TDE with EKM
  • Checking Status
  • Backups and Compression
  • Windows-Based Replication Options

Internals of Snapshot Replication

  • On the Publisher Server
  • On the Distributor Server
  • On the Subscriber Server

Configuring Transactional Replication Using the GUI

  • Configuring Publications
  • Configuring Subscriptions
  • Configuring Peer-to-Peer Transactional Replication

Configuring Transactional Replication Using T-SQL

  • Configuring Publication
  • Configuring Transactional Publication with Updatable Subscriptions
  • Configuring Peer-to-Peer Transactional Replication
  • Configuring Bidirectional Transactional Replication
  • Transactional Replication Stored Procedures

Internals of Transactional Replication

  • Concurrent Snapshot Processing
  • The Transaction Log
  • The Log Reader Agent
  • The Queue Reader Agent
  • Transactional Replication with Queued Updating
  • Transactional Replication with Immediate Updating
  • Peer-to-Peer Replication
  • Standard Transactional Publication

Configuring Merge Replication Using the GUI

  • Configuring Publication
  • Configuring Subscriptions

Web Synchronization with Merge Replication

  • Web Synchronization Basics
  • Configuring a Publication for Web Synchronization
  • Configuring IIS for Web Synchronization
  • Configuring Subscriptions for Web Synchronization

Configuring Merge Replication Using T-SQL

  • Configuring Publications
  • Configuring Subscriptions
  • Identity Range Management
  • Merge Replication with Filestream
  • Merge Replication Stored Procedures

The Internals of Merge Replication

  • The Merge Agent
  • Subsystems and Proxies
  • Publication and Subscriptions
  • Conflict Detection and Resolution

Backup and Recovery of Snapshot and Transactional Replication

  • Snapshot Replication
  • Transactional Replication

Backup and Recovery of Merge Replication

  • Publication with Download-Only Articles
  • Log Shipping with Download-Only Articles

Optimizing

  • Optimizing Snapshot Replication
  • Optimizing Transactional Replication
  • Optimizing Merge Replication

Heterogeneous Replication

  • Snapshot Replication from an Oracle Publisher to a SQL Server Subscriber
  • Transactional Replication from an Oracle Publisher to a SQL Server Subscriber

Nevyhovuje Vám osnova ?All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs