chore: add migration test and verification scripts
