Will this manual replication plan work?

1.To be more specific, at Date1, we want to detach US DB, copy and attach to PacRim.

2.On Date1, also turn on differential backup transaction log on PacRim DB

3.Set Identity Odd# + 2x increments for PacRim Db

4.Set Identity Event# + 2x increments for US Db

5.After pilot user testing on PacRim Db went well, we then want to repeat this.

Few weeks after Date1, detach the existing PacRim DB.

6.Then detach US DB (Date1+few weeks new data), copy and attach to PacRim.

7.Then Restore the PacRim DB transaction log from Date1 onto the 2nd time Attached PacRim DB which is the US DB (Date1+few weeks new data).

The utimate goal is PacRim DB =

(US DB + US few weeks new data) + PacRim few weeks new data

Will task#7 Restore produce expected result for PacRim DB having both odd and even # Identity?

For illustration, User inserts 2 records with transaction log turned on.

“TableX from PacRim” (Identity ID seeded (1, 1 + 2x) => Odd # ID

ID, Name

1, A

3, C

“TableX from US” (Identity ID seeded (0, 0 + 2x) => Even# ID.

ID, Name

2, B

4, D

What will be the result after applying transaction log (insert A & C)

from “TableX from PacRim”

to “TableX from US”?

Expected Result

“TableX from US”?

ID, Name

2, B

4, D

1, A

3, C

Or

UnExpected Result

“TableX from US”?

ID, Name

2, B

4, D

6, A

8, C

Many Thanks,

Jeffrey