Presentation On Database Replication

Presentation on Database Replication

Contents 

Introduction



Why use database replication?



Replication process

Cont… 

Replication types



Replication levels



Some more uses



Pros & Cons

Introduction

Why use it? 

Increasing database access for users



Offline processing



Backup

Replication Process 

Publishers



Subscribers

Types 

Snapshot Replication



Transactional Replication



Merge Replication

Replication Levels 

Master Mirroring



Peer Mirroring

Some more uses 

Share data among offices



Share data among dispersed users



Make sever data accessible

Cont.. 

Distribute application updates



Backup data

Advantages 

Greater autonomy



Backup & recovery



Decreased balance on server

Limitations 

Difficult to maintain



Updating problem



Security



Costly

Thanks Pr esent ed by: Nitin Kapo or Ri cha Shar ma