You should edit the reload.sql command file as needed when creating remote databases. For example, you must edit the reload.sql file in the following cases:
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 Extracting databases for a multi-tier hierarchy system.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |