Which replication to use? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Which replication to use?

Which replication to use?# Database - 数据库

a*t2009-04-28 07:04

1 楼

We want to out source our .com server hosting, and need to upload data from
our database server to .com database server nightly.
Possible methods:
Transactional replication (log shipping) - problem is if .com database needs
to be offline for server maintenance, or they have to switch to a "staging"
server, log shipping is broken and we'll have to reset the log shipping.
Merge replication - it's a two way sync. we don't want that.
Snapshot replication - seems the most promissing. the database is

w*e2009-04-28 07:04

2 楼

你自己都做了决定了呀,,,,就是最后那个Snapshot Repl.

from
needs
staging"

【在 a*******t 的大作中提到】

: We want to out source our .com server hosting, and need to upload data from
: our database server to .com database server nightly.
: Possible methods:
: Transactional replication (log shipping) - problem is if .com database needs
: to be offline for server maintenance, or they have to switch to a "staging"
: server, log shipping is broken and we'll have to reset the log shipping.
: Merge replication - it's a two way sync. we don't want that.
: Snapshot replication - seems the most promissing. the database is