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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Rebuilding databases

Reasons to rebuild databases Next Page

Rebuild considerations


The rebuild (unload and reload) and extract procedures rebuild databases and create new databases from part of an old one. Before rebuilding a database, you should consider how to go about the process.

Consideration...For information, see...
What is involved in rebuilding a database

Rebuilding databases

Reasons to rebuild databases

The available tools for rebuilding Rebuild and reload tools
The impact that rebuilding has on the database users Minimizing downtime during rebuilding
Whether or not the database is involved in synchronization or replication

Rebuilding databases involved in synchronization or replication

Rebuilding databases not involved in synchronization or replication

Changing the collation sequence of the databaseChanging a database from one collation to another
Whether materialized views need to be refreshed Refreshing materialized views

Rebuilding databases not involved in synchronization or replication
Rebuilding databases involved in synchronization or replication