New replication features in SQL Server 2005

1
New replication features in SQL Server 2005

• Meir Dudai
• SQL Server Consultant
• Valinor SQL Server Consulting Services
• meir_at_valinor.co.il

2
Agenda

• The innovative DBA
• New replication enhancements
• Oracle publishing
• Web synchronization
• Merge replication enhancements
• DDL replication
• Peer-to-peer transactional replication
• Summary

3
Agenda

• The innovative DBA
• New replication enhancements
• Oracle publishing
• Web synchronization
• Merge replication enhancements
• DDL replication
• Peer-to-peer transactional replication
• Summary

4
Problems DBAs have

• Database is one point of failure
• Database is a bottleneck in many systems

5
What we want

• Application/website always online
• Distributed workload amongst many servers (scale
  out)

6
Agenda

• The innovative DBA
• New replication enhancements
• Oracle publishing
• Web synchronization
• Merge replication enhancements
• DDL replication
• Peer-to-peer transactional replication
• Summary

7
Oracle Publishing

• Designed specifically for Oracle Publishers
• v8 on any operating system
• Administered like SQL Server, from SQL Server
• No Oracle side software install necessary
• Requires minimal knowledge of Oracle
• Leverages existing SQL Server skills
• Standard Transactional and Snapshot Publications

Transactional Replication
SQL Server 2005 Distributor
Subscribers
8
Web SynchronizationMerge Replication
Publisher/Distributor
IIS
Subscriber
-InternetUrl https//myserver.mydomain.com
Replisapi.dll
Firewall
9
Mobile application web sync
10
Database Schema Changes

• One of the key problems in SQL Server 2000
  replication is schema changes without disrupting
  replication
• SQL Server 2005 supports adding, dropping, and
  modifying columns without stopping replication
• Alter table alter column( foo int )

11
Logical RecordsMerge Replication

• Guarantees related rows are delivered together

12
New monitoring tools

• Monitoring Goals
• Provide answers to common questions
• Why is the system slow?
• How long until it catches up or finishes?
• Where are the potential problems?

13
Replication monitor
14
More exciting enhancements

• Replication of partitioned tables, full-text
  index
• Resume-able snapshot application
• Subscription initialization from backup
• Simplified wizards
• Performance!

15
Agenda

• The innovative DBA
• New replication enhancements
• Oracle publishing
• Web synchronization
• Merge replication enhancements
• DDL replication
• Peer-to-peer transactional replication
• Summary

16
Peer to Peer Topology
London
Chicago
Transactional Replication
Tokyo
17
Peer-to-Peer Transactional Replication
18
Session Summary

• Be innovative!
• Expand your high availability and scaling
  abilities with Peer-to-Peer replication

19
(No Transcript)
20
New York! New York!

• ??? ?????? ?????
• ? - email ???? ?? ???
• ? -Beat Center

• ?? ???????
• ????? Feel The Beat
• ??????? ?????? ?????? ????
• ?????? i-mate ????...(??????? ???? ??? ???)

21
(No Transcript)