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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Deployment and Administration » SQL Remote Administration » Extracting remote databases to a reload file

 

Editing the reload.sql file

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:

Adding unreplicated tables to remote database

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.

Extracting procedures, triggers, and views

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.

Using the Extraction utility (dbxtract) in multi-tiered systems

See Extracting databases for a multi-tier hierarchy system.

See also