Database cleanup

To reduce disk usage and shorten migration time to PostgreSQL, the following actions are recommended.

Test companies

• Remove test companies that do not contain important data to exclude them from migration. This can be done using the Monitor Installation Manager. New test companies can be created once the production company is running on PostgreSQL.

• Removing a test company does not delete its database; database files remain stored on disk. If disk space needs to be freed, the database can be manually deleted from the database folder.

• Performing this cleanup before migration will reduce migration time.

• New test companies can be created once the production company is running on PostgreSQL.

Production companies

• After migration, review SQL Anywhere production databases and backups.

• If appropriate, consider moving, compressing, or deleting databases or backups that are no longer needed.

• At a minimum, retain at least one copy of each production database for a period after the migration.

Important: Always confirm that the PostgreSQL databases are fully functional and verified before deleting any SQL Anywhere databases or backups.