Comparing and merging databases

[Paul_rachel_ryan]

We have been using Zionworx for a while now and it works great. However, over time and migrating between PCs and 2-3 users, we have managed to get 3 versions of the database. Leads to the horrible sinking feeling of a song being announced in a service and it not being in the database (even though you could have sworn it was there!).

Anyway, does anyone have a tool which can
1. compare 2 databases (even by exporting titles to text and using WinDiff or such)
2. Merge the databases (I know there is the 2.0 merge tool but is there one for 2.5?

Many thanks in advance
Paul

[Jonathan Hills]

The simplest thing would be to use the database which has the most songs in it and use the import command to import from the other 2 databases.
The import discards ones it already has.
I don't think there's much mileage in doing a compare, you will need to go through the list manually - For example, Yesterday, Today and Forever is also known as Everlasting God, but no compare will pick that up.