Unload the schema and data for local objects
in the 12.7 IQ Local Store, and move them to another node for migration.
Prerequisites
Upgrade
to Sybase IQ 12.7 ESD #5 at a minimum before local store
migration.
Task- Run the 12.7 iqlsunload utility against
each query server with a local store.
- Edit the reload_schema.sql
- Edit the extract_data.sql script
to remove objects that you do not want to migrate. These objects
are generally the same ones that you removed from reload_schema.sql.
- Use Interactive SQL to run extract_data.sql from
your 12.7 local store.
You now have unloaded the schema and data for local objects
in the 12.7 local store.
- Run the reload_schema.sql and reload_data.sql scripts
against the 12.7 write server.
Note: If you prefer, wait until the write server has been
migrated to 15 and run the reload_schema.sql and reload_data.sql scripts
against the new 15 coordinator.