Hi all,

i've a question/problem:

we are using several sql server at several locations.
Now we want to replicate the data from all servers to "one central
server".
After long time of searching the internet an reading different aricles
i decided to use the transactional replication for my problem.
But i didn't found anything if i could replicate data from several
servers to one "central server".
Hope someone here can help me.

Greetz Thomas

Thomas,
this is referred to as multiple publishers and a central subscriber. The
setup is quite straightforward, and the only tricky thing is the name
conflicts tab, where you'll have to use the 'Keep the existing table
unchanged' option.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

ps your English is v.good, while my German is non-existant :)

Thomas,
you could store the data in different databases / tables on the central
server and amalgamate it using a view. That is one option. It won't perform
well as it won't have an index though, so for a large table this could be an
issue. It would be more usual to replicate to one central table and
partition the data in some way eg have an additional column which has a flag
displaying the source server/business unit and in that way the source of
each row is identifiable. There aren't any articles that I am aware of, but
once I've finished the one I'm on at the moment, I'll create one and post
you the URL.
Rgds,
Paul

Ok, thanks for the answer.

Ok, i see it is possible to do this.
But is it also possible to store the data from the servers in different
databases/virtual sql servers on the "central server"?
So that we can differentiate which data is from which server?
Are there any links to a documentation in the internet? i couldn't find
anything......

[quoted text, click to view]

thanks :)


Greetz
Thomas

ok, big thanks to you paul! :)

[quoted text, click to view]

that sounds really good! :))


greetz
Thomas

Thomas,
hope this helps:
http://www.replicationanswers.com/CentralSubscriberArticle.asp
Rgds,
Paul Ibison

[quoted text, click to view]

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> schrieb im Newsbeitrag
news:%233yjPRcRFHA.2228@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

Hi Paul,

that's great! And again a big thanks to you!!

Greetz
Thomas