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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-05 : 09:11:36
|
| Kevin writes "I want to rollup four databases that contain different data but identical schemas.Let's say the database contains info on Sales Reps. I have one in the North, South, East and West and each contains data relevant only to that geo.Now I want to roll all of the data into a new central database.I don't want to do a two-way merge replication, because I don't want East to have West data.And I don't want to use snap/trans replication because then each of the sites would have to become a publisher (maintenance issues).So, I want to define a one-way merge to an empty database and then have SQL keep it up-to-date.Any help? thanx Kevin" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-05 : 11:46:38
|
| I think you would be better off using DTS and writing some custom packages that import the data that you want.Replication will work, but not given the requirements (Only the central Server can be the publisher, and East can't have West's data)-Chad |
 |
|
|
|
|
|
one-way rollup with merge replication?