Compare SQLite schema and data easily and quickly using SQLite Compare!
Compare SQLite schema and data easily and quickly using SQLite Compare!
Thanks for great software! I used it to merge SMS databases on my iPhone. And it works like a charm.
Alex Maltsev
SQLite Compare
SQLite Compare compares the schema of two SQLite database files and quickly locates the differences in tables, triggers, views or any other object in the database.
In addition - SQLite Compare analyzes the data differences between any two tables and allows you to drill down to the field level and see/edit the differences that were found.
You can move schema changes from one DB object to another by using the intuitive schema diff/merge view that allows you to treat schema structures as if they were simple text files!
Top features:
- Blazing fast in-memory schema comparisons.
- Optimized data comparison engine capable of comparing even huge tables with millions of rows!
- WinMerge-like schema difference view - now you can apply schema changes as if you are doing simple text file merge operations!
- SQL change script generation - useful for supporting database upgrades in existing installations
- Intuitive data difference view - merge rows between database tables, view and edit individual field differences with ease.
System Requirements
- 256MB RAM
- 40mb of disk space plus extra space for data comparison files (dependant on compare size)
- Windows 2000 or higher
Important Note: SQLite Compare does not handle the older SQLite 2 file format which is incompatible with the newer SQLite3 libraries.
If you really want to compare older SQLite files then you'll have to convert them to the newer file format by following the instructions at http://www.sqlite.org/formatchng.html
