Get data from multiple sources - consolidate data

[Former Member]

Recently I was given the need to make queries on cross-bound and consolidated data from multiple tables and on data from multiple clients. The information is only in one sense "Client -> Base Centralizer", do not need all information, are just some tables chosen. All clients run Sybase Adaptive Sql Anywhere 9.0.2.3951

The "centralizing" structure is brand new and can be assembled as we wish, could use current versions! What would be the suggestion to feed this centralizing base? Mobilink?

Many thanks!

DRauber

[Breck_Carter]

Yet another possibility is to run UNLOAD SELECT ... FROM ... TO 'filespec.txt' statements on the SQL Anywhere 9 database, manually transport the filespec.txt files to the central computer, and run LOAD TABLE FROM 'filespec.txt' statements on the SQL Anywhere 16 database.

[VolkerBarth]

My response will be delayed, but hopefully Volker or Breck can step in if you have questions.

I hadn't read Reg's PS but apparently he's right:)

[Former Member]

Hello! Other services in the company use this technique, but some tables are quite large and the result has been poor. In addition to needing relationships, we often have flaws. Thank you!

-- Outros serviços na empresa usam essa técnica, mas algumas tabelas são bem grandes e o resultado tem sido ruim. Além de precisarmos de relacionamentos, que frequentemente tem apresentado falhas. Obrigado!

[Former Member]

Is there any method I could periodically collect the log and run all the commands in a mirror database? (Using ASA 9)

[Breck_Carter]

The closest automated method is dbbackup -l for a live backup, BUT that's for backup, not creating a parallel mirror database for independent queries... which is what you want, right?

High Availability doesn't exist for version 9... but SQL Remote does, which is what folks often use for parallel database copies.

[VolkerBarth]

but SQL Remote does, which is what folks often use for parallel database copies.

...although I guess the typical setup would be to use SQL Remote to copy data to another site (that being the "remote") whereas here there's the additional need to "merge" the copied data in one place, if my understanding is correct, so that place would usually need to be the "consolidated" database...