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 |
|
Windza
Yak Posting Veteran
61 Posts |
 Posted - 2008-11-04 : 23:49:21
|
| Hi all... I'm hoping someone can recommend a suitable method for what I'm trying to achieve in terms of maintaining two identical DB's that are both functional for users in terms of reading/writing data.My understanding of replication and synchronisation is that rep. is simply a method of reproducing a back-up/failsafe DB identical to the source/functional DB (i.e. uni-directional) while sync. is used to update DB's with data from both ends (i.e. bi-directional - this essentially creates a 'virtual' database). Is this a reasonable deduction?If so, is there DB sync. software available that will allow real-time sync.(I'm using MSSQL 05 Express)? Also - what are the general rules in terms of handling synchronous data from multiple users (i.e two users accessing a single record).Your input would be most appreciated...Regards, |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-05 : 01:17:23
|
| you are correct in the sync and replication concepts.there are several tools for this. you can check vyas narayanan's website for the list of toolshttp://vyaskn.tripod.com/thirdparty.htmArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|
|
Synchronisation Vs. Replication