Posted by uli2003wien on 12/06/05 12:27

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

• Next in forum: Need Material for "Sybase to Sql Server Migration"
• Prev in forum: Re: Indexing and Queries
• Thread view: Replication of several satellites into one central db: adding location key ?

[Reply to this message]