In our environment we have multiple SQL instances that host the content databases. Just tried to copy a site collection from one content database on one SQL instance to another content database on a different SQL instance. Unfortunately I got the following message:
"The databases need to be on the same database server in order to combine them"
It looks like the command does not support multiple SQL instances, which would be a real shortcoming.