s********e
发帖数: 78 | 1 Urgent, need everyone’s help, any feedback will be very much appreciated.
SQL 2008 R2 Replication VS Mirroring Or other technology
Client need push data from each satellite server(10 regional server) to a
single repository in real time.
Requirement
1. Data transfer cross internet, low latency.(data volume low, shouldn’t
be a problem)
2. Each satellite server has only one db with identical name/layout, so
eventually the result should looks like
SourceServer SourceDB TargetServer TargetDB
Server1 db server99 db_server1
Server2 db server99 db_server2
Server3 db server99 db_server3
……………
Server10 db server99 db_server10
3. Need to be able to generate script and modify and deploy to each
satellite server, or deploy to center server.
Now in terms of technology, can choose from transactional replication,
database mirroring, or any other simple solutions. | s********e
发帖数: 78 | | a9
发帖数: 21638 | 3 先用中文写个摘要吧？看了半天看累了
【在 s********e 的大作中提到】
: anyone can give idea?
| s**********o
发帖数: 14359 | 4 都需要在SAME DOMAIN里，DATA走INTERNET，还REALTIME不可能吧，
看个MOVIE还一愣一愣的呢，再说就是没有数据变化你也要有
DEDICATED带宽才行，否则员工看了个电影，数据就DELAY了。
我看你这个得用个LOG SHIPPING+FTP，不能保证REALTIME，
其实最简单的办法弄个VPN弄到一个DOMAIN里不就行了，
REPLICATION，但是INTERNET一断，DATA OUT OF SYNC，
需要重新初始化。想省钱不弄自己的DOMAIN总是付出代价的。 | i****a
发帖数: 36252 | 5 am I reading it right that you need to be able to update both sides? so are
you
you can cross mirroring off the list because the mirrored DB is read-only.
you'll need to replicate data both ways, from satellite servers to centeral,
and from central to satellite.
http://msdn.microsoft.com/en-us/library/ms152761(v=sql.105).asp
’t
【在 s********e 的大作中提到】
: Urgent, need everyone’s help, any feedback will be very much appreciated.
: SQL 2008 R2 Replication VS Mirroring Or other technology
: Client need push data from each satellite server(10 regional server) to a
: single repository in real time.
: Requirement
: 1. Data transfer cross internet, low latency.(data volume low, shouldn’t
: be a problem)
: 2. Each satellite server has only one db with identical name/layout, so
: eventually the result should looks like
: SourceServer SourceDB TargetServer TargetDB
| s**********o
发帖数: 14359 | 6 是单向的还是双向的不是很清楚，这个还不是关键，只要是不在一个NETWORK上，
搞不懂为什么SEPARATE SERVER，一个地方一个IT DEPT啊，维护费用老去了。
数据量不大，用CLOUD不好吗?
are
centeral,
【在 i****a 的大作中提到】
: am I reading it right that you need to be able to update both sides? so are
: you
: you can cross mirroring off the list because the mirrored DB is read-only.
: you'll need to replicate data both ways, from satellite servers to centeral,
: and from central to satellite.
: http://msdn.microsoft.com/en-us/library/ms152761(v=sql.105).asp
:
: ’t
|
|
