The Migrator is a utility that upgrades (migrates) PANTHEON 5.0 to 5.5, which cannot be accomplished with normal upgrades within PANTHEON.

Migration is a process that alters the database structure, converts reports to a different format and establishes referential integrity, all in order to make a PANTHEON 5.0 database usable in PANTHEON 5.5.

The Migrator does not completely convert SQL-i procedures, which must be converted manually.

1  Preparation

1.1  Backup

Make backup copies of all your databases before starting the migration process.

Backups of PANTHEON databases can be created:

• from the Administration Panel in PANTHEON (Database | Backup), or
• with the SQL Query Analyzer utility (isqlw.exe) that comes with MS SQL Server.

1.2  List of Databases

Make a list of databases that you want to upgrade. Remove the databases that you don't need.

1.3  SQLI-i Procedures

The Migrator does not completely convert SQL-i procedures to ARES DPAs. Consult you support provider before migrating SQL-i procedures.

1.4  Migration

It is recommended to run the migration on the computer that runs the database server and holds the relevant databases.

1.5  Upgrade PANTHEON 5.0

PANTHEON 5.0 must be upgraded to the latest available build before the migration.

If upgrading manually, you will need (from ftp://ftp.datalab.si/upgrade/[loc]/release/, where [loc] is the localization you need):

• database upgrades
  (file named like STR_[loc]_FULL_21xx.zip), and
• the PANTHEON executable
  (file named like dlPantheon_SI_SI_21xx.ZIP), where xx marks the latest build available.

1.6  Migrator Folder

Create a folder for the Migrator. Make sure you have the privileges to do so.

It is recommended to create this folder within PANTHEON's installation folder. Give it an obvious name, like Migration55.

1.7  Download Migrator

Download the migrator from Datalab's FTP site ftp://ftp.datalab.si/Programi/DL-utils/. Look for a file named like dlMigration_xx.zip, where xx denotes the version of the Migrator. Get the latest one and save it to the migration folder you created earlier.

After the download has completed, extract the archive to the same folder. To do so, right-click the file and select Extract All....

Type in or browse for the migration folder you created earlier.

After the extraction is completed, click Finish to close the Extraction wizard.

2  Migration

2.1  Start Migrator

Start the Migrator by executing dlMigration55.exe in the migration folder.

Enter a user name and password - the same you are using to log on to PANTHEON 5.0.

That user must have full authorization in PANTHEON. The migration is not possible for users with limited privileges.

Select the companyyou want to migrate. If you are migrating multiple databases you can select any of them.

The Server and Database field show the server name and database name of the selected company.

Click Nadaljuj (Continue).

2.2  Upgrade Database

• Poti | Novosti (Paths | Upgrades) -  the folder from which the migration will run
• Poti – varnostna kopija (Paths | Backup) - the folder where backups will be stored
• Poti - Program (Paths | Executable) - the folder where PANTHEON's executable can be found

Click the Migracija (migration) button to start the migration process.

The migration of a 1 GB database lasts rougly 1 hour, depending on your hardware.

The log on the right will display a history of the Migrator's actions.

The Migrator will download the following files to the migration folder (from ftp://ftp.datalab.si/upgrade/[loc]/release/, where [loc] is the localization you need):

• database structure upgrades
  STR_[loc]_FULL_55xxxx.7z
   (alternatively, in a Zip archive STR_[loc]_FULL_55xxxx.zip),
• report conversion tool
  dlMigration55ReportRepl.zip
• PANTHEON 5.5 executable
  dlPantheon_SQL_[loc]_[loc]_55xxxx.ZIP
  
  [loc] is the localization you need; xxxx is the PANTHEON build number

The migration is finished when the log dsiplays::

End: Database upgrade (1)
End: Upgrade successful

The log is automatically save to a file, named like NadgradiBaze_time_stamp.log.

3  Start PANTHEON 5.5

3.1. Server

After the migration is finished, find a file named like dlPantheon_SQL_[loc]_[loc]_55xxxx.7z in the migration folder and extract it to PANTHEON's installation folder.

Create a desktop shortcut to Pantheon55_SQL.exe.

3.2  Workstations

Copy Pantheon55_SQL.exe from the computer where you performed the migration to all workstations that will be using PANTHEON 5.5. Create desktop shortcuts for convenience.

3.3  Run PANTHEON

At first start, click the Refresh button to refresh the list of companies/databases. Pantheon 5.0 databases are not shown in the list.

4  Log

The log shows a history of action that the Migrator has performed. The log is also saved into a file for later review. The log file can be found in the migration folder or the upgrades folder (where the upgrade files are downloaded into).

The log file is named like NadgradiBaze_YYYYMMDDHHMMSS.

Migration phases:

• Start upgrade(phase 1)
• Prepare data (B-before the upgrade)
• Prepare data (A-after the upgrade, only build 500000)
• Prepare data (B-before the upgrade)
• Prepare data (A-after the upgrade)
• Prepare data (R-fix reports)
• Prepare data (R-convert reports)
• Errors when comparing original and migrated data
• Fill in missing records (referential integrity).
• Check users
• End upgrade (phase 2)

5  More Information

Migration instructions at Datalab's web site:
 http://www.datalab.eu/index.php?id=3819

Video "Migration to 5.5" from the Pantheon Conference 2008 (in Slovenian):
 mms://media.datalab.si/si/pancon08/Migracija_na_55.wmv