How to do database migration unit test between releases

I have an Android app with a database with version 1.

Now I added a data column in one table and I have done a migration into a new release.

The problem I have is how to do unit tests for this. I needed to check if old data are correct inserted in the new structure and the new column is added and filled in the right way.

How would I best do this? Thanks in advance.