Migrating from Zim 7.1x for Windows to Zim 9.00 for Windows

This procedure exports the definitions in the Data Dictionary to text files and optionally exports existing data into ASCII files.

1. If necessary, start a single-user Zim 7.1x session in the original database directory or skip to step 2

2. Continue on the same Zim 7.x session and check whether it is necessary to create a document called zim8cnv1

> list 1 docs where docname=”zim8cnv1″

If the document exists, skip ahead to step 5.

3. Copy the file zim8cnv1.cmd from the Zim 9.50 installation path to the original Zim 7.x database path

4. Create a document corresponding to the zim8cnv1.cmd file

> aft docs
zim8cnv1 zim8cnv1.cmd
> create doc zim8cnv1

Or

> add docs let docname=”zim8cnv1″ filename=”zim8cnv1.cmd” dirname=”ZIM”

> create doc zim8cnv1

5. Locate the file config.db in the Zim 7.x database directory. Create it if necessary

6. In config.db, add or update the following configuration options:

parameter size 32000
directories <number of Zim directories of your application + 10>
files 100

Warning

It is necessary to add 10 to the number of directories in the Zim 7.x application to account for internal directories.

7. Exit and restart the Zim 7.x session if there were any changes made to config.db

8. Close the Zim Development Center window after if it pops up

9. From the Zim 7.x session prompt, run zim8cnv1

> zim8cnv1

zim8cnv1 will add all object definitions to the \port directory in the original database path

It will also ask whether to export the data in the original Zim 7.x database to ASCII files:

Do you want to download all your data into ASCII documents? (y/n)

If you choose to export the data, you can skip phase f – step 7.

However, there is no need to export the data, since the destination database will also be in the same Windows format.

Warning

1. Exporting the data is required when migrating the database from Windows to Linux or vice-versa.

2. The script only exports the object definitions in the database, but does not copy files such as dirs.zim and areas.zim.

3. It is the administrator’s responsibility to ensure the accuracy of these files and to copy them to the appropriated places.

10. Write down the values of maximum tables and directories reported after the migration program terminates

These values will be used in phase e – step 3

11. Exit the Zim 7.x session

✓ The Zim 7.1x database is now exported. It is now time to move over to the Zim 9.00 destination database.

Stop ZimServer if it is running

On Windows 7 and higher, you can double-click on Stop ZimServer using any of these shortcuts:

Desktop	Taskbar	Start Menu

2. In x64 versions of Windows, you need to confirm the admin priviledges through the User Account Control dialog and allow ZimServer to start or stop.

3. Update Configuration Files

In phase b – step 10, zim8cnv1 reported that the values of maximum tables and directories may need to be changed in the Zim 9.00 configuration files:

As summarized in the table below, use the indicated parameter and values to:

a. Modify zimconfig.srv in the Zim 9.00 installation path

Locate the maximum tables parameter and edit the value.

b. Create zimconfig.zim in the destination path

Add the directories parameter and the value.

File	zimconfig.srv	zimconfig.zim
Action	modify	create
Location	installation path	destination database path
Parameter	maximum tables	directories
Value	max of 400, existing value or reported value	max of 10 or reported value

✓ The destination database is now created, configured and ready to receive the object definitions from the original database

Warning

The following script must be executed on a newly created Zim 9.00 database (see phase d) and should never be executed twice over the same database.

1. Start ZimServer 9.00

Double-click on the Start ZimServer using any of these options:

Desktop	Taskbar	Start Menu

2. In x64 versions of Windows, you need to confirm the admin privileges through the User Account Control dialog and allow ZimServer to start or stop.

3. Start ZimQt Client and create a connection to the destination database

On Windows 7 and higher, you can double-click on ZimQt Client using any of these shortcuts:

Desktop	Taskbar	Start Menu

a. Click on ( + ) to add a new database to the connection list

b. Add the database name in DATABASE and leave COMMAND empty

You may leave HOSTNAME as localhost if the database is located on the same machine as ZimQt Client. If so, continue in step d

c. Change the HOSTNAME to the IP address of the machine where the database was created

d. Click on the check mark (✓) to accept all changes

e. Click on shortcut to initiate a connection to the destination database

4. Run the database importer script (zim8cnv2) in ZimQt Client

a. Finalize the database creation

> zomenable

This completes the creation of all object structures in the Data Dictionary according to the latest version of ZOM.

b. Keep file numbers after migration

let <UseExistingFileNum>=$true

Important: This guarantees that all user-created data-base objects, such as entity sets and relationships, are created using the same zim01xx files in the destination as in the original database.

c. Run Import Script

> zim8cnv2

This script creates database objects based on the definitions stored in /port in the destination database path.

d. Wait until the script terminates

5. Stop ZimServer

ZimServer should not be running while data files are being imported.

On Windows 7 and higher, you can double-click on Stop ZimServer using any of these shortcuts:

Desktop	Taskbar	Start Menu

6. In x64 versions of Windows, you need to confirm the admin privileges through the User Account Control dialog and allow ZimServer to start or stop.

Warning

1. In phase b – step 9, if you chose not to export the data from the original Zim 7.x database path, you have to copy the physical data files to the destination Zim 9.50 database path.

2. The internal structure of logical directories and physical directory files inZim 9.00 changed from the previous versions of Zim.

7. Import the user-created data files from the original database path

a. In the Zim 7.x database path, select data files named zim01xx and higher

b. DO NOT select files with a corresponding zim01xx.ws operating system directory

For example, do not select zim0123 if there is a operating system directory called zim0123.ws.

c. Copy all selection files and paste them in the destination Zim 9.00 database path.

8. If there are any special files in the original Zim 7.x database, such as programs, documents, and images, they must be manually copied into the destination Zim 9.00 database path

9. Start ZimServer and use ZimQt to connect to the new Zim 9.00 database

a. Start ZimServer as described in phase f – step 1

b. Start ZimQt Client as described in phase f – step 3

10. Test all you applications to ensure they are working as before the migration

✓You have finished the migration process. You are now ready to run you migrated database applications on ZimQt while connected to the new Zim 9.00 ZimServer