search

sqlitebrowser / sqlitebrowser

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
https://sqlitebrowser.org
Other
21.21k stars 2.14k forks source link

Compare Database Files #158

Open Tythesly opened 9 years ago

Tythesly commented 9 years ago

Possibly add the feature to compare 2 separate database files to find differences in the tables... Possibility? Or just a dream?

justinclift commented 9 years ago

That'd be useful, though I suspect it could be a bunch of work. :smile:

blitzmann commented 9 years ago

Differences in schema or data?

Tythesly commented 9 years ago

Lol I smell a challenge... First one to make it happen gets extra credit rofl.

I tried using beyond compare (http://www.scootersoftware.com/index.php) to compare the csv files... but it takes forever xD... I was thinking because your program is fast and easily navigates through all the data that it would be a great feature.

Tythesly commented 9 years ago

Differences of the data in the tables

mgrojo commented 7 years ago

Wouldn't sqldiff help you?

https://sqlite.org/sqldiff.html

justinclift commented 7 years ago

@mgrojo Yep, that should work.

drescherjm commented 7 years ago

This works for me: https://www.codeproject.com/Articles/220018/SQLite-Compare-Utility

With that said it synchronized dates will detect as different.

justinclift commented 7 years ago

Cool. :smile:

Looked over the sqldiff cli tool (briefly) recently, as I need to implement something like it in Go for our dbhub.io web platform thing. Hadn't come across that "SQLite Compare Utility" before... it looks useful, and it's Open Source. Might look over the source/approach it uses too when I get around to writing the Go version. :smile:

Tythesly commented 7 years ago

Sweeeeet. Exactly what I need :D

Also im happy to see that this is still active after i posted the request 3 years ago haha ^^

thenatsky commented 4 years ago

I would also love to see this feature. sqldiff is ok for very basic comps but it doesn't support views and triggers. It would be awesome to have a visual diff of the create statements for tables, views and triggers at least.

MKleusberg commented 3 years ago

We have added this to our online platform dbhub.io a while ago. So in theory you can upload your database files (and make them invisible for other users too if you wish) and it keeps track of the different versions of your database. The differences are determined in a way which resembles sqldiff but the presentation is more visual and easier to read.