@karthik p​  migration is a different story I would say.

just few ideas, to migrate data to different metastore / UC one could use delta sharing then transfer the data. You have many options here for example deep copy, insert into new table, etc.

other option is to setup external locations in your current workspace/uc end export data to external tables.

thanks,

Pat.