473,387 Members | 1,791 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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
1 1161
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Byron Cooke-Tonnesen | last post by:
QUESTION: We are looking to migrate from a Microsoft Access database to MySQL for our CRM application. However one of our requirements is the ability to synchronize partial replicas - both from a...
1
by: Sindri Mar | last post by:
Hello everybody I work at a company in Iceland and we have developed a 3-tier solution written in ASP - Visual Basic - MSSQL2000, 4 companies are using the solution almost constantly and...
2
by: HJ | last post by:
Hi all, I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. The...
2
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection...
1
by: Andrew Chanter | last post by:
I developed 3 different replicated database applications in MS Access for 3 different corporate clients in Access 97 several years ago to enable data to be shared across wide area networks. I...
6
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops...
4
by: bfausti | last post by:
I have never used replication before and I have been asked to consider it in a project I am currently working on. I have created an application for a sales team which is loaded on their...
0
by: Curt | last post by:
I am planning a replication project where we will be rolling up data from several (about 5) offices into a central database that will be used for management reporting. The tables I want to...
0
by: | last post by:
My organization has several locations downloading/uploading financial transactions from a central location, to/from several places in the world every day. It's a labor-intensive effort for the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.