当前在线人数12180
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: 请教sql server DB 大侠
[同主题阅读] [版面: 数据库] [作者:xlxie] , 2007年01月24日20:34:01
xlxie
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: xlxie (三老爷), 信区: Database
标  题: Re: 请教sql server DB 大侠
发信站: BBS 未名空间站 (Wed Jan 24 20:34:01 2007)

search for DB replication for the second question.
for the first one, I recommend you create a seperate DB for DB warehousing
or other usages.
It all depends on what kind of Production DBs you got.
I assume they are OLTP, not OLAP.
It also depends on what kind of reporting and how fast you want that done.
How big the DBs are, how powerful your production servers and the offline
servers are, etc.
Anyway, my point is your question is too large to give a simple solution.


【 在 mirthcyy (百无聊赖) 的大作中提到: 】
: 要是我有些production db在好几个sql server上, 现在要把这些db create 一个
: offline的db copy用于别的reporting. 第一次我可以restore backup files, 然后根
: 据reporting需要作些index调整什么的, 然后我想要create nightly job to do
: incremental data load from the production dbs to offline dbs,不做schema
: changes.  问题是我怎么才能作incremental load? 怎么来track changes on
: production db 做synchronization? 我知道有些utility象sql data compare可以一个
: 一个db compare, 但是我想要的是schedule一个job同时能做好多个db的
incremental
: data load. Any scripts or reference or advice is appreciated.



--

※ 来源:·BBS 未名空间站 http://mitbbs.com·[FROM: 69.138.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996