I would like to compare Sqlite databases with each other, both schema and data. I know that a rather crude method exists by comparing the database dumps with each other. But are there any other methods as well? Especially from a command line environment. I know several tools for comparing databases exist (such as Redgate), and I would like to know what sort of methodology they use in order to create a similar tool myself.