Skip to main content
Awais
Silver ⭐️
May 29, 2023
Question

Apache Nifi Transfer data from MSSQL to Postgres thousand+ tables

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

Awais
AwaisAuthor
Silver ⭐️
May 29, 2023

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

Translate