Internals of Windows-to-Windows SQL Server data transfer
There is a difference:


An RDBMS is optimised for such bulk row operations
A client app has to process row by row


You have factors like:


buffering of output while the client consumes it but for an RDBMS this doesn't matter
SQL Server + Windows integration
choice of engine in MySQL