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 - 2006-03-20 : 05:17:45
|
| Hi I am looking at SQL Replication and merge replication seems like the solution as I have 30 Remote offices who will all add data to their data bases and sync that data back to a central office. The central office will then use the "whole" data for reporting etc.I am trying to figure out if I need static or dynamic filtering. I only want to filter horizontally on values found in a column called 'office' This value will be an integer that represents the different remote offices. But after reading through documentation I am still unclear as to whether I can do this with static filters. Any help/advice appreciated.Regards and TIAICW |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-20 : 06:26:32
|
| If you aren't changing the data on the central DB, you could just use transactional replication as there will be less overhead.. If you are looking to update the data on the central DB, then you are stuck with merge, which does have a fair overhead..As for your filtering, yes this can be done. |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2006-03-20 : 06:47:56
|
| Thanks for this. Does transactional allow for the model of several remote updaters to one central subscriber? Does this mean absolutely NO updates on the central server? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-20 : 08:30:56
|
| Yes it does and absolutely none if you want that data to be a reflection of your sites.. You can make changes to it, but the integrity won't hold, you can create other objects though.. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2006-03-20 : 09:08:15
|
| ThanksICW |
|
|
|
|
|
|
Merge Replication