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.py
in 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