|
Microsoft SQL Server
Microsoft SQL Server is a relational
database management system (RDBMS) produced by Microsoft.
SQL Server includes support for database mirroring and
clustering. SQL Server also supports data replication and
spanning three different scenarios; Snapshot replication,
Transaction replication, and Merge replication.
Microsoft SQL Server
includes support for database mirroring and clustering. A
SQL server cluster is a collection of identically configured
servers, which help distribute the workload among multiple
servers.
Database mirroring allows creation of mirrors
of database contents, along with transaction logs, on
another instance of SQL Servers, based on certain predefined
triggers. SQL Server supports
three different types of data replication.
- Snapshot replication takes snapshots
of a database and pushes it out to all replication
subscribers of a server.
- During transaction replication, the
changes to the database are continually published out to
the clients.
- Merger replication synchronizes the
database with other servers participating in the
replication. Changed to all databases happen
independently and during replication, the changes are
synchronized among all databases. Merge replication
includes in-built support for conflict resolution.
|
