Installation guide

6
Preparing the IMPAX
database and archive
for the upgrade
You must perform certain tests and backup tasks to prepare the IMPAX 5.2 or 5.3 Database and
Archive Servers for the upgrade. IMPAX 4.5 sites cannot upgrade directly to IMPAX 6.5.3; they must
first upgrade to IMPAX 5.2, then update the study comments (refer to page 102), then perform the
other tests and backup tasks.
If migrating a WEB1000 site, no particular WEB1000 Server tasks are required.
Updating study comments after upgrading to
IMPAX 5.2 from IMPAX 4.5
(Topic number: 10040)
1.
CAUTION!
This topic applies only when upgrading from IMPAX 4.5. This query must not be run if
upgrading from IMPAX 5.2 or 5.3; doing so would overwrite database data.
This query works with both SQL and Oracle databases.
You cannot upgrade an IMPAX 4.5 database directly to IMPAX 6.5.3; you must first upgrade it to
IMPAX 5.2.
After upgrading the IMPAX 4.5 database to IMPAX 5.2, we recommend that you run the following
command to update the study comments field in the database. If you do not, the upgrade time from
IMPAX 5.2 to IMPAX 6.5.3 greatly increases.
AS300 Preparing to Upgrade Guide—IMPAX 4.5, 5.2, 5.3,or WEB1000 to IMPAX 6.5.3 102
Agfa Company Confidential—Subject to Non-Disclosure Obligation