Run the 12.7 iqlsunload utility against
each query server with a local store.
Edit reload_schema.sql:
Delete unwanted objects.
Change any commented objects in the reload_schema.sql that
you want to reload.
Add commands to define any objects that you defined
in sp_mpxcfg_<servername> procedures.
Edit extract_data.sql to remove objects you do not want to
migrate. These objects are generally the same ones 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 version 16.0 and
run reload_schema.sql and
reload_data.sql against the new
coordinator.