Duplicate object should work across database servers
Currently the duplicate object is only capable of copying tables and other objects on the same host. There does not seem to be any reason why it could not work across hosts. Thsi would be handy to easily migrate objects from a development server to production.
This operation is best completed with schema/data comparison tools.
-
Markm commented
Agreed! This would also relate to my suggestion -- "Copy or Move via Drag & Drop".
It seems to me it would be relatively easy to add a drop-down to the "Duplicate Object" dialog box to allow selecting a "connection", and also a tick box if you want to "move" the object.