a*******t
发帖数: 891 | 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*******e
发帖数: 1622 | 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
| j*****n
发帖数: 1781 | 3 Using SSIS could be more flaxable since you only need nightly feed.
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
| a*******t
发帖数: 891 | 4 that's what I was think too
【在 j*****n 的大作中提到】
: Using SSIS could be more flaxable since you only need nightly feed.
:
: from
: needs
: staging"
| a*******t
发帖数: 891 | 5 need to test if snapshot replication puts the target database off line
【在 w*******e 的大作中提到】
: 你自己都做了决定了呀,,,,就是最后那个Snapshot Repl.
:
: from
: needs
: staging"
|
|
