root/misc/sqlite2to3.sh

#!/bin/sh

if [ $# = 0 ]; then
  echo "Usage: $0 sqlite2-db-file..." 1>&2
  exit 1
fi

for fname in $*; do
  echo "Processing: $fname" 1>&2
  old="$fname"2
  mv "$fname" "$old"
  sqlite "$old" .dump | sqlite3 "$fname"
  eval "`stat --format='chmod %a \"$fname\"; chown %u:%g \"$fname\"' \"$old\"`"
done