SSIS, tsql, linked servers could help get the job done.

You would probably want to batch the migration. It wouldn't be hard to do it via a sql agent job and run a regular schedule to migrate the top n records.

The hard part would be that you would need to do is map out the source to the destination columns.