Support Questions

Find answers, ask questions, and share your expertise

Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables

avatar
New Contributor

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.

1 REPLY 1

avatar
New Contributor

@mburgess 
@TimothySpann
Kindly have a look. I have seen you both suggesting wonderful solutions. Will really appreciate your kind suggestions