exec sp_msforeachdb 'select filename from ?..sysfiles'

will tell you where your databases are living

Technically speaking that could work but you would need to make sure

it is practical...ie

How much data would you be pushing across the linked servers ?

Do you need indexes on...