Installation guide

b.
In the Data Link Properties dialog, select Microsoft OLE DB Provider for SQL Server.
Click Next.
c. In the Data Source field, type mvf_ts.world or the name of the tns entry that was created
in tnsnames.ora.
d.
Select Use a specific name and password and type the database user name—normally
sa.
Do not specify the password at this time.
e.
In the Select the database on the server field, type mvf.
f.
Click OK.
4. In the Migrate training/traveling server data dialog, under Source, type the database password.
Sample configured Source settings in Migrate training/traveling server data dialog
5. Under Destination, supply the database information for the training server database, as follows:
a.
Click Modify.
b.
In the Data Link Properties dialog, select Oracle Provider for OLE DB. Click Next.
c. In the Data Source field, type mvf_ts.world or the name of the tns entry that was created
in tnsnames.ora.
d.
Select Use a specific name and password and type the database user name—normally
dbadmin.
e.
In the Select the database on the server field, type mvf.
f.
Click OK.
6. On the training server, the database password will be encrypted. To retrieve it, use the following
command at C:\mvf\bin:
passkey -M QUERY -u sa
Then type the retrieved value into the Destination Password field.
7.
Click Migrate Data.
A DTSResults dialog opens showing the result of the data migration from the training to the
production server. Scan it for any ERROR messages that you need to resolve.
8. When the migration is complete, close the DTSResults dialog.
The training server database is now staged with report data from the production server database.
AS300 Preparing to Upgrade Guide—IMPAX 4.5, 5.2, 5.3,or WEB1000 to IMPAX 6.5.3 76
Agfa Company Confidential—Subject to Non-Disclosure Obligation