Is there a tool that will compare two .gwbks and output the specific differences between them? I’m trying to roll my own here as I couldn’t find one, but curious if there’s anything out there.
Use case: I have a dev / test environment that has diverged somewhat from the online production environment, so I don’t want to do a wholesale .gwbk restore, but need to make sure I don’t miss anything when restoring to the production environment piece by piece.
The .gwbk is just a renamed ZIP file, so I would focus your efforts on the .idb files within. SQLite publishes a program called SQLDiff which would theoretically give you an idea of the differences between the two internal database files.
Be aware, though, that this way lies a lot of potential trouble. Any manual changes you make to the internal database are not guaranteed to work, and can very easily break the entire file. Backup your backups, as it were.
That’s what I’m thinking. I’m just looking for a “what changed” that would allow me to manually export / import from the Designer… there’s no way I’d try a manual DB merge on something like that.
I’ll update if I come up with anything.