开发者

Synchronizing two Sql Server 2008 databases in same instance

开发者 https://www.devze.com 2022-12-17 02:44 出处:网络
I want to synchronize two databases (DB1 and DB2) present in same instance. Lets say if i cr开发者_StackOverflow中文版eate a table or make any changes to a existing table (e.g. altering the structure

I want to synchronize two databases (DB1 and DB2) present in same instance.

Lets say if i cr开发者_StackOverflow中文版eate a table or make any changes to a existing table (e.g. altering the structure) in one database DB1, those should be reflected on the other database DB2

Please help

Savitha


A few options...

Replication Log shipping Triggers

The choice depends on your other needs.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号