User guide

Ready to upgrade database from current system version <version-number>.
Do you want to proceed [q to quit]?
Verify that the version_number listed is correct—for example, that it says 62 if upgrading from
IMPAX 6.2. If so, press Enter to continue.
If the version is incorrect, type q and press Enter, then repeat the previous step with the correct
version number specified.
5. Respond appropriately to other prompts that appear.
The database is upgraded.
Checking the upgrade status2.
After upgrade the database, check the log file to ensure that the upgrade was successful.
To check the upgrade status
1. Open the log file called
C:\mvf-mig6\data\logs\migrate_database_from_IMPAXversion_number.log
where version_number is the IMPAX version you are upgrade from, such as 52 or 63.
2. If the following warning appears in the log file, you can safely ignore it:
Warning: The table 'CHANGE_CONTEXT_DETAIL' has been created but its
maximum row size (8095) exceeds the maximum number of bytes per row
(8060). INSERT or UPDATE of a row in this table will fail if the
resulting row length exceeds 8060 bytes.
3. Ensure that Migration Complete Successful appears at the end of the log file.
4. If this message does not appear, review the rest of the log file to see where the upgrade failed.
Solve the problem, then rerun the upgrade script.
Backing up the AS300 SQL database3.
After upgrading the database on the previous-version server, you must back it up so that you can then
restore it onto the new IMPAX 6.4 server.
You must be in the SQL application environment to run the backup command.
To back up an AS300 SQL database
1. On the server running the AS300 database, select Start > All Programs > Microsoft SQL Server
> Enterprise Manager.
2. In the Explorer window of the Enterprise Manager, expand Console Root > Microsoft SQL
Servers > SQL Server Group > server > Databases > database
where server is the name of the SQL Server IMPAX is running under and database is the name of
the database to be backed up.
3. Select Action > All Tasks > Backup database.
AS300 Upgrade Guide—IMPAX 6.2 or later to IMPAX 6.4 32
AGFA COMPANY CONFIDENTIAL