Home > database, sql server > sql server 2008 replication vs mirroring

sql server 2008 replication vs mirroring


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-

Categories: database, sql server Tags:
  1. No comments yet.
  1. No trackbacks yet.

Please kindly Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: