No wonder when you want to change your mobile you want to keep your SMS for history purposes, in my case I want to buy an Android Enabled mobile and sell my iPhone 2G, and I have old SMSs that I want to keep, so I searched a little and here is my solution scenarios.

First Scenario

Buy a 1$ app to do that for you!

Second Scenario

Follow the following steps

Prerequisites:

1. iPhone Browser
2. SQL Lite 3
3. Notepad ++

After downloading all these software, plug your iphone and do the following:

1. First open up iPhone Browser and navigate to User/Library/SMS/sms.db and download it to your pc, lets say on C:\mySMS\sms.db

   

2. open your command prompt -after installing sql lite 3- and navigate to cd C:\mySMS\
3. write the following codes
sqlite3 mySMS
.restore sms.db
.output mySMS.txt
Select address, datetime(date,'unixepoch'), text from message;

4. To separate messages by a line feed, open Notepad++ and hit ctrl+f, go to replace tab and check the Regular Expression check box, and put the following in Find what ^(.+\|.+\|) and put the following in Replace with \n\1

And voala you have a text file with all your SMSs in it!

You only have to go for each mobile number and change it to the equivalent name by replace all functionality in Notepad++

PS: this is all your sms, sent and received, If you want only sent then change your query to “Select address, datetime(date,’unixepoch’), text from message where flags=3;” or “Select address, datetime(date,’unixepoch’), text from message where flags=2;” for received messages.