By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,441 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Replication of several satellites into one central db: adding location key ?

P: n/a
Dear group,

i have the following setting:

satellite databases in different locations with the same structure (and
sometimes identical data) need to be replicated into one central
database. The databases hold information on machine results and
machines are numbered from 1 to n.

Results for machine 1 in location 1 should be entered in the central
database whereas results for machine 1 in location 2 should also be
entered.

Thus i would need a copy of the tables in the satellite database which
adds one column for "location id" (or something like that).

Is there an easy way to accomplish this ? Seems to me that the
replication scenarios in the "replication wizard" for SQL-Server miss
out this case.

Some hint at documentation or websites would be extremely helpful.

Thanks + Greetings from Vienna

Uli

Dec 6 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think i have the "solution" and it is not solving the problem. I have
to insert a "location" column into each table which is to be replicated

Dec 6 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.