Installation guide

SQL Server databases
For a SQL Server database, on a computer supporting user ID sa, password sa, and ODBC name
mvf, the batch file can be run directly. Otherwise, you must specify the mvf user, mvf password,
ODBC name, in that order.
Examples:
build-impax-mig-schema.bat sa pwd new
Runs the command for user sa, password pwd, and ODBC name new.
build-impax-mig-schema.bat
Runs the command for user sa, password sa, and ODBC name mvf. These default values do not have
to be specifically included; however, if problems occur in running this script, specifying these values
may solve the problem.
Oracle databases
For an Oracle database, run the script with no additional parameters.
build-impax-mig-schema.bat
database-upgrade-script.bat
(Topic number: 10613)
Upgrades the IMPAX 5.2 or later SQL Server database schema to IMPAX 6.5.3. This is a batch file
that the user runs, which calls the executable file that handles the main part of the database upgrade.
The database-upgrade-script requires a report source. Reports are retrieved from IMPAX clusters
based on matches between the report source and the value of the dosr_study table's requesting_service
field, which is set by the Connectivity Manager’s requesting_service field during HIS verification.
Check the Connectivity Manager for the value of the requesting_service field. This field is
case-sensitive.
To check the value of the Connectivity Manager's requesting_service field
1. On the Connectivity Manager, open osql and type
use mcf;
select distinct requesting_service from mcf_service_request;
Note:
If this Connectivity Manager receives data from multiple report sources, several
requesting_service values may match each report source. If multiple values are returned,
consult a Connectivity Manager integrator, as data and mappings may need to be updated.
Default valueValuesParameters
C:\mvf-mig6\datadump_file_location_for_MAP_EVENT_and_MAP_EVENT_AUDIT
-l
C:\mvfpath_to_IMPAX_installation_directory
-x
AS300 Upgrade and DAA Consolidation Guide—IMPAX 5.2 or 5.3 to IMPAX 6.5.3 77
Agfa Company Confidential—Subject to Non-Disclosure Obligation