1 Reply Latest reply on Dec 14, 2017 1:21 PM by Ramesh Reddy

    migrating materialized tables from postgresql to mysql

    Omar Khan Novice

      Hi,


      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?

       

      Omar