Migrate Local Stores

To move the 12.7 local stores before migration, use iqlsunload.

To migrate your local store, consolidate node-specific information into either the existing 12.7 writer or the new SAP Sybase IQ 16.0 main store. Customize the process to meet your data requirements.

For query nodes with node- or department-specific information, use tablespaces and partitioning to achieve the same results.

If information is duplicated across your query nodes, you may need to migrate only a single query server's local store. The duplicated information on the other query servers becomes redundant and can be ignored for multiplex migration.

• Partitioning Query Server Data
  If the same table exists on multiple query nodes, and each node has its own subset of the data, manually edit the local store migration scripts.
• Addressing Overlapping Query Server Data
  If the same table exists on each query node with overlapping data sets, you must resolve the issue. Extract the data files to ensure that data sets are unique, or rename the tables and then reload all the unique tables.
• Moving Local Stores
  Unload and move the 12.7 local stores.