What is the difference between replication and mirroring in SQL Server 2008
replication, is to replicate or duplicating one or some transaction in primary server to target server:
- copy selected table to target server,
- need primary key on table to be publish
- it is not working in fail-over server concept
- best practice for publishing data to webserver / website
- can be replicated to 2 or more replicate server
- need to modified manual if the primary server created a new object/field/sp
mirror, is 1=1 server, all data, object, transaction in one server is same in other server:
- primary server is mirroring server,
- mirror can be use as fail-over server concept
- it is not best practice for integrating publishing data to webserver / website
- taking resources in server more than replicate
- 1=1 connection from primary to mirror server
- automatic creating object on mirroring server while the primary add some object (sp/table columns/view)
so, the replication and mirroring concept has a different goals
-RF-