[Feature][Manager] Kafka sink supports all migration

[Yizhou-Yang]

Description

No response

Use case

No response

Are you willing to submit PR?

• [X] Yes, I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct