An XML snippet for copying a SQL stored procedure is shown here:
<dmCreate> ... <database selection="unselected"> <name>database1</name> <table selection="included"> <name>test</name> </table> </database> <stored_procedures> <stored_procedure selection="included"> <name>macro1</name> <database>database1</database> </stored_procedure> </stored_procedures> ... </dmCreate>