It would be require great care to convert all the record IDs from one of the galleries to new IDs for the merged gallery. It might be possible. It would mainly be difficult in being very fastidious about all the fields and IDs. I don't think it's impossible, but it might be.
In any case, there wouldn't be that many people who would use such a thing, so I don't think anyone would spend the time to code such a tool unless it were a personal project.
If you have the skills, go for it. It sounds like you have the motivation to do so. And consider sharing once done.
If not, besides batch-adding the photos from one to the other (and recreating the albums & categories using maybe the MassImport plugin), you might post on the Freelancer board.
There are two plugins that might help, but I don't think they would work "out of the box", as they are now.
- File2AlbumMover: mirrors your albums in your folder names - I don't think it handles categories though
- Mass Import: mass-creates categories & albums based on your folder & file structure
I could imagine applying the first plugin to one gallery to re-organize the files & albums, then copying the new albums folder to the other gallery, then using MassImport to pull them in to effectively merge the galleries. But this might not work with how the plugins are currently written.
At the very least, you could manually organize one gallery's photos into folders with the album names, then using MassImport to add them to the other gallery. That should work well with a day's work or so. If your current albums mirror the folders fairly well, you may just have to rename the folders before using MassImport.
Remember to backup your files & database first. And test out whatever you do with a small number of files first. MassImport is a very powerful but also a very frantic tool.
