Before and After Migration Files

Migration generates a set of files from your legacy database. Migrating the IQ 12.7 demo database to Sybase IQ 15.4 creates this set of corresponding files.

Files before and after migration

Before

After

Description

asiqdemo.db

asiqdemo.db.before_schema_reload

The 12.7 catalog database. This file is copied at the OS level upon successful migration; it is not a result of the SQL backup command.

asiqdemo.log

asiqdemo.log

The database log file is regenerated when the migrated database is used with the 15.4 server.

asiqdemo.iq

asiqdemo.iq

The old Sybase IQ 12.7 IQ_SYSTEM_MAIN dbspace. This file and all other user dbspaces are not affected by the migration process. This dbspace is added as a file to a user main dbspace.

asiqdemo.iqtmp

asiqdemo.iqtmp

The IQ_SYSTEM_TEMP dbspace. No operations are performed on this dbpace during migration. This file becomes the IQ 15.4 database temporary store.

asiqdemo.iqmsg

asiqdemo.iqmsg.before_schema_reload

The IQ 12.7 message file. This file is copied at the OS level upon successful migration.

asiqdemo.db

The new 15.4 migrated catalog database.

new_main_store.iq

The new IQ_SYSTEM_MAIN dbspace for the migrated database.