I'm trying to copy metadata from SDE (Test) to SDE (Prod) environment. Any help would be greatly appreciated.

You can set the SDE reader to read only metadata: To write the metadata, set the geodb_type atribute of the feature containing the metadata to 'geodb_metadata'. More information and examples can be found here: Working with Geodatabase Metadata: Writing/Updating Metadata