Installation guide
Identifying the report source
(Topic number: 68030)
5.
When upgrading the database, you will be prompted for the report source. When prompted, supply
the value stored in the requesting_service field in the Connectivity Manager database. To prepare
for the upgrade, identify this value in advance.
To identify the report source
1. On the Connectivity Manager, open osql (refer to page 123) 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 SQL 2000 database
(Topic number: 11497)
6.
In case of problems, back up the database before upgrading it.
Note:
Before backing up the database, confirm that you have stopped the IMPAX services, emptied
and halted all queues, and shut the database down.
To back up the SQL 2000 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 > MVF
where server is the name of the SQL Server IMPAX is running under.
3.
Select Action > All Tasks > Backup database.
4.
In the SQL Server Backup screen, in the Backup section, select Database–complete.
5.
Click Add and specify the directory to back up to.
AS300 Preparing to Upgrade Guide—IMPAX 4.5, 5.2, 5.3,or WEB1000 to IMPAX 6.5.3 105
Agfa Company Confidential—Subject to Non-Disclosure Obligation