Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2007-11-07 : 05:45:11
|
| Hi All,A general question for you.Does QSL replication work on a row by row basis or field by field.e.g.One user updates a field in row a on his tablea different user updates a different field on the same row (row a) on his table 10 secs later.Does the first user's chnage get overwritten or will both chnages be kept?Which model would I need for this?Thanks |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-07 : 10:13:29
|
| the general idea of replication is synchonization. if you make two changes to the same row you have only the latest data in that row, the same holds true for the replicated copy. you can also take a look at books online if that wasn't the question you were asking. |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-11-07 : 13:01:18
|
| If that is the case then SQL replication (synchronisation) is not as sophisticated as I had first thought.I thought i would be able to have several remote databases, with every body updating records and then syncing with all field changes being kept and most recently updated fields being kept rather than the whole row. |
|
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-07 : 15:43:43
|
| you may be wanting more of a change capture solution, it is supposed to come with sql 2008. or you can buy a third party solution. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-07 : 23:39:43
|
| Which replication do you use? If you use transactional replication, sql replicates every transaction. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-11-09 : 00:19:08
|
| Thanks for your answers so far, but it is still unclear to me.Are you saying that transactional replication will sync my databases on a field by field basis rather than a row by row basis? e.g. I have a database that has a row that contains address and contact info for Ms Jacqui Smith , and i change the phone number on that row (because Ms Smith has a new phone provider!) and my colleague changes the status of Ms Smith to Mrs Smith (because she just got married!) When we sync our databases do we both get both changes or does one of us get overwritten?Thnks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-09 : 23:56:47
|
| Not column by column nor row by row, it replicates transactions. Whatever statement ran on publisher will be replicated to subscriber. In your case, sql replicates both update statements. That means updating phone number then status. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-11-10 : 01:28:25
|
| Great, it look slike that's the one i want then.Thanks very muchICW |
|
|
|
|
|
|
Field or row replication