I was wondering if the process to migrate materialized tables would be as follows from PostgreSQL to MySQL?
1. Migrate the schema and data using a facility such as mysqlworkbench or squirrel sql from PostgreSQL to MySQL.
2. Change the JDNI Name on the source for the model where tables are materialized to
3. Redeploy the VDB on the Teiid instance
Am I missing any large steps that would be needed, or would that be it for the most part?
Looks about right. Change the translator name on the materialization model too. You do not need to transfer that data, you could always regenerate if that is not expensive.
Retrieving data ...