Could User Macros please be included in a site backup/restore? The only way to have them survive between backups at the moment is by backing up the 'confluence.home' directory. However, if you are transferring between databases this isn't much help.