Production Schema Step 3: Audit and Migrate

Run the full audit against your SQLite database before moving anything: wrong types, orphaned foreign keys, duplicates in soon-to-be-unique columns, nulls in soon-to-be-required ones. Write down what each one is and decide what happens to it. Then migrate a copy, run the application against it, and note everything that breaks. Throw the copy away and do it again from your notes. Reset the sequences. Then restore from your backup once, on purpose, so you know it works.