Richard Lesses has created a great article on cloning Maximo 7.6 here:
https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/Cloning_Maximo_7_6?lang=en
In the comments you'll also find a link to this MSSQL script that Brian Baird uses to update several values after cloning:
https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/Cloning_Maximo_7_6?lang=en