November 21, 2002 at 1:17 am
Hi All,
I just want seek an advice about Database design. I have 2-3 databases on different location with some common tables and those get replicated at the end of the day. I am thinking of introducing the surrogate keys is it a good idea or should i use other approach mean proper 3NF design, i need some advices. What are the best approaches for replication in this scenario from DB design point of view. I mean when to use surrogate keys etc.
Regrads,
Affan
November 25, 2002 at 8:00 am
This was removed by the editor as SPAM
November 26, 2002 at 9:34 pm
If you're going to use merge it makes you add a guid as a column, which makes a great key and you dont have to deal with identity ranges on each box. Worth doing to me.
Andy
November 26, 2002 at 9:51 pm
Thanx for replying,
So what i was thinking that i will create the proper relationship and then GUID will help me as unique column which i will not need if i create proper relationships.
Kind REgards,
Affan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply