Nov 12, 2009

SQL Server Replication

Replication is the process of creating and maintaining a separate copy of database in another server or the same server and keeping both synchronized. Replication is useful in a number of scenario:

1. To integrate multiple database to build a central warehouse: Businesses operating on a number of distant locations usually collect data in separate database. However the senior management needs to generate reports showing analysis of data collected from all these sites. Hence the need for central warehouse is increasing and replication proves to be a powerful way to create and maintain the warehouse. It can also be used to create and maintain a separate data mart for OLAP operations.

2. To ensure higher availability and improved performance of web applications: Web applications with the increasing number of users faces huge problem in avoiding the extra load on the database. Replication along with other techniques can offer the right solution by distributing users to a number of replicated database in different servers and thus improving the performance and ensure high availability.

2 comments:

datakid said...

Good one. You might be interested to take a look at the collection of Tutorials and videos on MS SQL server.
Tutorials: http://www.dataminingtools.net/browsetutorials.php?tag=mss

Videos: http://www.dataminingtools.net/videos.php?id=3

benslin kard said...

Data warehousing creates one database, the number of sources can be nearly limitless, provided the system can handle the volume.