A simple tool to generate SQLite queries out of two different sqlite files. There is currently no easy way to compare changes between two .db3 files.
- Install any version of Python3 >= 3.7
- Make sure you have downloaded this repository
- Copy your old and new sqlite files to where you downloaded this repository to
- Run python sqlite_diff.pyin this folder with your command line tool
- Follow the instructions printed out (enter the name of the files)
- Look for an output file that was generated by the script ending with .sql
- Basic functionality of generating INSERT, UPDATE, DELETE statements based on table differences
- Generate statements for handling of changes in table structure based on sqlite documentation
- UI functionality of selecting files