I need to migrate from one database to another where the existing volume of data is at least 2TB and at least 200 million messages. I also need to do some transformations as part of the migration as the destination database expects a different format
Both databases offer official connectors that I know that I can use
Is Kafka-connect recommended for this type of workflow?
The main challenge that I have is that I need to be able to migrate data of a production system that it is still receiving traffic