Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.
If you have to re-extract the schema for the second-level database from the top-level consolidated database, the Extraction utility (dbxtract) deletes the remote users (Laptop 1, Laptop 2, and Laptop 3) along with their subscriptions and permissions. As a result, you must recreate those third-level users and their subscriptions manually.
If you only have to re-extract the data from the second-level databases from the top-level consolidated database, the Extraction utility (dbxtract) does not affect the remote users. See the -d option Extraction utility (dbxtract).
Fully qualified publication definitions contain WHERE and SUBSCRIBE BY clauses. In most cases, you do not need to extract fully qualified publication definitions for a remote database, since the remote database typically replicates all rows back to the consolidated database.
|Envoyer votre avis sur cette page par email.||Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|