Change an Installation Location with Unloading (Windows)
Follow these steps to change the value of II_SYSTEM, II_DATABASE, II_CHECKPOINT, II_JOURNAL, II_DUMP or II_WORK. "II_SYSTEM" is used as the example location to be changed:
1. Unload each database. For details, see the Database Administrator Guide.
2. Remove the old installation files by removing everything under the old %II_SYSTEM%\ingres directory and any extended locations.
3. Reinstall Ingres specifying the new value of II_SYSTEM.
4. Recreate each of the databases. For details, see the Database Administrator Guide.
• Use the createdb dbname command to recreate a database.
• Reload each database by appropriately editing and running the reload script.
5. Once you have reinstalled Ingres and recreated the databases in the new location, take new checkpoints of each of the databases. Checkpoints taken in old locations are no longer valid. For details, see the Database Administrator Guide.