Do replicated tables need identical? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Do replicated tables need identical?

Do replicated tables need identical?# Database - 数据库

e*n2010-08-11 07:08

1 楼

紧急求助：I485 pending 180 天，I140已批准且relink to I485 and under review.
现在要换新工作，需要transfer
I140? If yes, how to transfer?
Thank you very much for any input in advance!

l*b2010-08-11 07:08

2 楼

Hi, friends,
In SQL server 2005, I have case to build new DB in another location and have replication with
existed DB. They have same schema. My approach is:
1. backup the existed DB, restore to new DB
2. delete some old data in new DB - existed DB keeps 10 years data, new DB
maintain the recent 3 year data.
3. make two DB replication in sync - bi-direction transactional or merge
type
Does this work in not-identical data DB replication?
Thank you

l*b2010-08-11 07:08

3 楼

More, it is in SQL Server 2005

S*02010-08-11 07:08

4 楼

I have not used merge replication so far yet, but here is what I thought,
from the transactional replication standpoint, about your scenario, which
the publisher and subscriber are in different status.
1. Disable the Snapshot. During the replication configuration, you can
delay the snapshot, then even disable the snapshot job, so the snapshot will
never happen for this replication. This way, you can keep them in its own
status.
2. Another way is to use snapshot first, get both publisher a

【在 l*****b 的大作中提到】

: Hi, friends,
: In SQL server 2005, I have case to build new DB in another location and have replication with
: existed DB. They have same schema. My approach is:
: 1. backup the existed DB, restore to new DB
: 2. delete some old data in new DB - existed DB keeps 10 years data, new DB
: maintain the recent 3 year data.
: 3. make two DB replication in sync - bi-direction transactional or merge
: type
: Does this work in not-identical data DB replication?
: Thank you