(560) Data migration from AS400 to PC databases

QMirror/DB provides you a simple way to migrate data from AS400 to PC databases.

Live Data Migration Steps

1. Install and configure QMirror/DB

2. Select tables from AS400 libraries/PFs by taking command option 4
(Note: The empty physical files on the AS400 will not be processed by the trial version.)

3. Start journaling all tables by taking command option 8

4. Start QMirror/DB to download and replicate tables by taking command option 1
(QMirror/DB downloads all tables and replicates data from AS400 to PC databases in real-time) 

Once PC databases go production

5. Stop QMirror by taking Ctrl-C or command option 2

6. Stop journaling all tables by taking command option 8.
QMirror/DB removes extra columns, RRN400, TBUPDT, and TBUPTM from tables

7. Migration completed

Static Data Migration Steps

1. Install and configure QMirror/DB

2. Select tables from AS400 libraries/PFs by taking command option 4
(Note: The empty physical files on the AS400 will not be processed by the trial version.) 

3. Stop tables replication by SQL statement

UPDATE QMIRROR.ZAMTBF SET TBREPL=’N’,TBJLIB=”,TBJNAM=”

4. Start QMirror/DB to download tables by taking command option 1 
(QMirror/DB downloads all tables from AS400 to PC databases)

Once tables download completed

5. Stop QMirror by taking Ctrl-C or command option 2

6. Migration completed

Previous (550) Multiple AS400s / PC database servers configurations 
Next (570) Install QMirror/DB as a Windows Service