Installation guide
To identify the report source
1. On the Connectivity Manager, open osql and type
use mcf;
select distinct requesting_service from mcf_service_request;
2. To prepare for upgrading the database, note the value stored in the requesting_service field.
The requesting_service value is case-sensitive.
3. If multiple values are returned in the requesting_service field, consult a Connectivity Manager
integrator, as data and mappings may need to be updated.
If this Connectivity Manager receives data from multiple report sources, separate
requesting_service values may exist that match each report source.
Backing up the IMPAX production database
(Topic number: 123343)
8.
Perform a complete backup of the existing production database, to then be restored on the new
IMPAX Database Server. Services are stopped and removed as part of this process, so time it to
minimize disruption at the site, or use a travelling server during this period.
To back up the IMPAX production database
1. On the IMPAX production Database Server, open a command prompt.
2.
Change to the C:\mvf\bin directory.
3. Type
stopall.bat
4. Type
removeall.bat
Previous IMPAX versions may have a scheduled task to watch for stopped services and restart
them. The removeall.bat script removes the services (not the software itself), so that the services
cannot be restarted. This ensures that the system is cold so the backup is complete.
5. Repeat the preceding steps on the other IMPAX server stations in the production cluster.
6. On the production Database Server, go to or open a command prompt and type
isqlw
7.
When prompted, type sa as the user name and type the sa password.
8. To back up the database, type
backup database mvf to disk = 'file_path:\mssql\backup\oldserver.dat' with stats
where file_path is the location of the database files. For example
backup database mvf to disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\oldserver.dat' with stats, init
AS300 Upgrade and DAA Consolidation Guide—IMPAX 5.2 or 5.3 to IMPAX 6.5.3 31
Agfa Company Confidential—Subject to Non-Disclosure Obligation