Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables

Awais — Tue, 21 Apr 2026 07:08:35 GMT

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.

Re: Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables

Awais — Mon, 29 May 2023 14:01:17 GMT

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

question Re: Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables in Support Questions

Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables

Re: Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables