Onlydarksets

1. Download sqlite.
2. SFTP into the iPhone.
3. Download sms.db into the same folder.
4. Open a command window, navigate to the directory where sqlite and sms.db are, and enter the following:

c:\sqlite sms.db
sqlite> .output messages.txt
sqlite> select * from message;
sqlite> .output stdout
sqlite> .quit

That’s it – now you can import the messages.txt file into Excel and view the messages.