阅读背景:

SQL Server - 保持同步只读数据库

来源:互联网 

I need to keep synchronized a couple of databases, one is on sql 2000 and the other on 2005. The one on 2000 should be kept in read-only mode to make sure the users does not enter data. The 2005 is the one which are going to be updated by the users. So I could develop a script to truncate and insert into the 2000 version with data from 2005 every night. My question is if there is some way to disable the read-only mode temporaly while the script is running. Is there a better approach? Thanks,I need to keep synchronized a couple of databas




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: