Installation guide

To update study comments after upgrading to IMPAX 5.2 from IMPAX 4.5
1. Launch CLUI.
2. Type
Update DOSR_STUDY set study_comments_utf8=study_comments where study_comments
is not null
The study comments in the database are updated, reducing the amount of time required to later
upgrade this database to IMPAX 6.5.3.
Running a final report on study archiving status
(Topic number: 6631)
2.
While you may have already run a report on study archiving status (Running an initial report on
study archiving status (refer to page 77)), you can do so again closer to the actual time of migration,
to ensure that you have the most up-to-date list of unarchived studies.
Run the following command on any computer with an MVF connection to the IMPAX 5.2 or 5.3
database.
To run a final report on study archiving status
1. At a command prompt, type
mig-study-archive-report.exe -U IMPAX_5.2_or_5.3_database_user -P
IMPAX_5.2_or_5.3_database_password -d mvf_version_number -o
where version_number is either 52 or 53.
This command returns a list of completely unarchived studies, partially unarchived studies, and
studies cached on disabled archive, and writes them to a file that CLUI can use to initiate store jobs.
To get different information returned, you can use different parameters, as outlined in Common
parameters in Migration Tool commands (refer to page 110), mig-study-archive-report.exe (refer to
page 115), and mig-study-archive-report.
Information on how to archive the remaining unarchived studies is provided in the AS300 Upgrade
and Migration Guide—IMPAX 5.2 or 5.3 to IMPAX 6.5.3 .
Checking the size of the map_event and
map_event_audit tables
(Topic number: 10773)
3.
To save time in database migration, large map_event and map_event_audit tables should be trimmed.
To check the size of the map_event and map_event_audit tables
1. On Windows, open the SQL Server Query Analyzer.
AS300 Preparing to Upgrade Guide—IMPAX 4.5, 5.2, 5.3,or WEB1000 to IMPAX 6.5.3 103
Agfa Company Confidential—Subject to Non-Disclosure Obligation