SQLite Diff is a graphical comparison tool for SQLite database files, comparing both the schema and the data. Schema results include comparisons of tables/columns, triggers, indexes and views.
Top 10 Features
- Quickly compares SQLite schema: Tables/Columns, Triggers, Views, Indexes.
- Record by record data comparison between each file.
- Colorized SQL and Data highlighting makes it easy to see changed SQL and data.
- Optimized for analyzing undocumented or poorly documented SQLite schemas.
- Fast in-memory schema comparison – runs fast even on older computers.
- Cross-platform compatibility with MacOS X and Windows.
- The only SQLite comparison tool on the market – no need to write your own tool.
- Instantly drill-down to see comparison details for SQL and data.
- Easy to use Drag & Drop interface.
- Economical single-user license includes MacOS X and Windows software. (Site License Available)
SQLite Schema Comparison
Comparing two SQLite database files is as simple as dragging and dropping the files onto SQLite Diff and pressing the Compare button. The schemas of each file are compared and the results are displayed in a few seconds. Clicking each object (Table, Trigger, View or Index) instantly displays the detailed results for the selected object.
SQLite Table Comparison
SQLite Diff first compares lists of tables by name between the two database files. Then the column names are compared between between the two SQLite database files. The Diff Results column shows a comparison result symbol for each table/column:
- ‘=’ Object Matches
- ‘+’ Object Added
- ‘-‘ Object Deleted
- ‘~’ Object Changed
You are allowed to use this product only within the laws of your country/region. SharewareOnSale and its staff are not responsible for any illegal activity. We did not develop this product; if you have an issue with this product, contact the developer. This product is offered "as is" without express or implied or any other type of warranty. The description of this product on this page is not a recommendation, endorsement, or review; it is a marketing description, written by the developer. The quality and performance of this product is without guarantee. Download or use at your own risk. If you don't feel comfortable with this product, then don't download it.
Reviews for SQLite Diff
I work in sqlite databases every day, so this program immediately caught my eye. With no install and a simply small .exe file, it looked good from the outset. Unfortunately, it went bad from then on.
The opening window looked good and ‘clean’, but it was quickly apparent we wouldn’t be friends. Maximising the application made the window larger, but forced it off-screen. Attempting to move the application ‘restored’ the window to a smaller size. The best we could get to was a resized window that took up 95% of screen space.
Clicking ‘Edit’ and ‘Preferences’ displayed the ‘About’ dialog box. Great. If the program has any preferences, I can’t access them.
The application I made in vb.net copies the database everytime the application starts, so I wasn’t short of sqlite databases. However, in a directory of 20 to 30 databases, the application only liked 5. However, it wasn’t sure *which* 5 it liked. If I dragged a database onto icon #1, it would drop and appear to take it (no errors displayed) but nothing would happen … if I dropped it on icon #2, the filename (4pt text under the icon … smallest font known to man … magnifying glass recommended…) would change. So it was valid for #2, but not #1. This happened for other databases – some could be dropped on #1 but not #2. All the databases could be opened in DB Browser – the Sqlite database app I normally use.
So once I got two databases the program liked (with no idea why it didn’t like the others) and compared them, the issues didn’t stop. In the data comparison tab, the summary database column headers text crashes into each other, so you don’t know what the columns represent. The columns can’t be resized, nor can the actual table be resized … so your database might have 2 columns and the program allows 85% of the screen width for data comparison … when you can’t use that space.
Argh. I’ve just gone back to the drag and drop page to try again – as the databases were the same, the data comparison wasn’t ‘working’, so wanted to review that side. Dropped a database and it didn’t work … tried again and it did. Finally worked out why. Where you drop your database to compare is a large (130 pixel x 130 pixel) square area. The cursor changes to a ‘drop’ icon (ala Explorer). The picture in that square is only 60×60 pixels. You’ve got to drop a file onto the picture, not the surrounding white space … so ignore what the cursor is telling you.
The final ‘grr’ moment was when the data compare was completed. That was actually fast and useful … what records have been added / removed in this database compared to the other one. Ooh, that record. I need to export that record, or copy it .. or …. nope. You can’t do anything. Just view.
Such great potential in a program, but just not quite there. This is like using Notepad, then trying to work out ‘how do you get bold text?’. ‘You can’t – its Notepad.’ ‘Oh ok – how can I convert it to PDF?’ Its not entirely the fault of the program, but it has so many limitations, you quickly realise its too frustrating to use.
Read Replies |
Thanks for your review, … save me time and aggravation.-
Submit Your Review
This is for reviews only. If you want to post suggestions or comments, ask questions, or need help, please post in the discussion forum.