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.
For a department-specific employee table
on each query server, follow these basic steps:
- Unload the schema and data from the query nodes.
The reload_schema.sql script
produced for each query node contains the same schema definition
for employee.
- Execute the reload_schema.sql from one of the query nodes
against either the existing 12.7 writer or the new
SAP Sybase IQ
16.0 main store.
- Execute the reload_data.sql script from each of the query
nodes against the same server.
This procedure creates the employee table
once but loads each query node data set.