While attempting to migrate data from MSSQL to Postgres with nearly a thousand tables, I am currently retrieving the list of tables (LDT) and splitting it into individual tables using splitAvro. Now, I'm seeking a solution to efficiently map these tables to their corresponding names in the target system and transfer the data to the tables that share the same names in both the source and target databases. Additionally, I would like to know if Nifi offers a feature to convert and migrate schemas between different databases.
Thank you.