Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Remote » Managing SQL Remote systems » Remote database extraction to a reload file

 

Database extraction for a multi-tier hierarchy system

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.

A three-tiered system. The middle tier databases act as both remote and consolidated databases.
 Create the remote databases for a three-tiered system
  1. Use the Extraction utility (dbxtract) on the top-level, consolidated database, HQ, to create the second-level databases Region 1 and Region 2.

  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.

 Re-extracting databases in a multi-tier hierarchy system
 Fully qualified publication definitions
 See also