Remote databases can have tables that are not present at their consolidated database as long as these tables do not take part in replication. The Extraction utility (dbxtract) and Extract Database Wizard cannot extract unreplicated tables from a consolidated database.

After extracting the database, you should edit reload.sql to add such tables.

By default, the Extraction utility (dbxtract) and Extract Database Wizard extract all stored procedures, triggers, and views from the database. While some of these views and procedures are likely to be required on the remote site, others may not be required. For example, a procedure could refer to parts of the database that are not included in the remote site.

After extracting the database, you should edit reload.sql to remove unnecessary procedures, triggers, and views.

See Database extraction for a multi-tier hierarchy system.

• Creating multiple remote databases
• Remote database extraction to a reload file