Database rebuilding on Windows Mobile

When rebuilding a database on Windows Mobile, you have the following options:

Rebuild the Windows Mobile database on another platform and then copy the database to the Windows Mobile device. This is the recommended method.
Repopulate an empty database using dbmlsync.
Repopulate an empty database using dbremote.
Use dbunload on the Windows Mobile device. This option is not available on smartphones.

The first three options are recommended when upgrading a Windows Mobile database. However, if these options are not available to you, you can use dbunload on Windows Mobile. Before deciding to use dbunload on Windows Mobile, you should consider the following implications of using dbunload on Windows Mobile:

the size of the database server's temporary file (both the unload and reload can cause this file to grow to several megabytes)
the extra space required for dbunload and related components
the extra cost of having multiple copies of a database on the Windows Mobile device

Because running dbunload on a Windows Mobile device can require more resources than some devices have available, upgrading the database on a different platform is recommended whenever possible.

Note

If you want to run dbunload on a Windows Mobile device, you must choose the Unload/Reload Support option in the Deploy SQL Anywhere 12 for Windows Mobile Wizard. You can modify your SQL Anywhere installation to add this support if you did not select this option when you first installed SQL Anywhere for Windows Mobile.

Notes about using dbunload on Windows Mobile

To use dbunload on a Windows Mobile device, ensure you have performed the following tasks:

The following files should be deployed to your SQL Anywhere installation directory (by default, \Program Files\SQLAny12):
- dbsrv12.exe
- dbsrv12.lic
- dbunlspt.exe
- dbunload.exe
- dbrunsql.exe
The following files should be deployed to the \Windows directory if you are intending to unload old (version 9 or earlier) databases and you are including dbunlspt.exe.
- scripts\optdeflt.sql
- scripts\opttemp.sql
- scripts\unloadold.sql
The following files should be deployed to the \Windows directory:
- dblgen12.dll
- dblib12.dll
- dbscript12.dll
- dbtool12.dll
- dbusen.dll
The Location string value (REG_SZ) should be set to the SQL Anywhere software directory, inside the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere\12.0\.

Rebuilding a database on Windows Mobile

Discuss this page in DocCommentXchange.