Database reorganization involves adding, modifying, or deleting application specific database elements to produce new or modified database tables required to support your applications.
If your application is transferred to a remote server using the Default method, database reorganization automatically occurs during application installation. Otherwise, databases can be manually reorganized. Errors encountered during database reorganization are logged to the DBReorg.log file. By default, this file is located at:
<NGEN directory>\Data\Public\Log
Since an existing schema does not exist for new deployments, database reorganization is responsible for creating required database elements.
Notes:
Before database reorganization occurs, it is recommended that you create a full database backup.
To reorganize a database, you must have sufficient user privileges on both the database reorganization module, and the targeted database.
User-maintained tables
A user-maintained table provides database performance features that might not be available with Developer.
It is your responsibility to ensure that user-maintained tables are consistent and reorganized with corresponding class definitions.
Restrictions
A consistency check cannot be performed when database reorganization is in progress.