To understand the role of the Extraction utility (dbxtract) and the Extract Database Wizard in multi-tiered arrangements, consider a three-tiered SQL Remote system. This system is illustrated in the following diagram.
Use the Extraction utility (dbxtract) on the top-level, consolidated database, HQ, to create the second-level databases Region 1 and Region 2.
Use the Extraction utility (dbxtract), on the second-level databases, Region 1 and Region 2, to create the third-level databases for users Laptop 1, Laptop 2, and Laptop 3. The second-level databases are remote databases to the first-level database, HQ, and are consolidated databases to the third-level databases, Laptop 1, Laptop 2, and Laptop 3.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|