sqladapter

This is exactly what Biztalk is designed to do.

You do not need to match the schemas, you map the messages.
Just create a new map using the schemas generated by each SQL adapter and connect the fields. Add a transform shape to your orchestration between the receive and send.