If you want to create a backup of your settings, messages and other system data you can do it by syncing your iPhone automatically and your text messages will be stored as a SQLite database file. Old text messages from an iPhone will be extracted by several programs and installing the SQLite shell on your computer and they can be extracted by yourself for free.
Old text messages will remain on your iPhone until you delete them and perform sync with iTunes and when you do the synchronization, deleted texts do not appear in the backup file that has been created.
Transfer
Step 1
First of all you have to download and install an iPhone SMS transferring program, like Tansee iPhone Transfer SMS, Aiseesoft iPhone SMS transfer or DiskAid. After that you can click “Finish” to launch the program at the end of setup.
Step 2
You have to connect your iPhone to your computer and choose it in the section of Device of the window. After that you have to pick a “Contact” button which is located from the list in case to view all old text messages that have been exchanged with this person and then you can click “copy” if you want to save these old text messages. Or you can do alternative way by clicking “Copy” if you want to view your Contacts list to transfer all old text messages in your iPhone.
Step 3
In this step you have to choose “Save as text File” and then click “Browse” to pick a location for the text file. You have to enter a name for the file and then click “OK”. Click “OK” to save the file and you can do it in the File Transfer window.
Shell
Step 1
In this step you have to connect your iPhone to yout computer, and then open iTunes and press “Ctrl B” in case to show the menu bar if it’s hidden. After that click “File”, point the cursor to “Devices” and pick “Back up”. If you have synced or backed up your iPhone and you already have a backup file in your AppData directory you can skip this step.
Step 2
Open the SQLIte website to download the most recent precompiled SQLite 3 Shell binary file. After that you have to right click the ZIP file and then select “Extract All”. Choose the extracted folder and press “F2” to rename it “sqlite3”. You can drag this folder to “Local Disk (C:)” and then click “Continue” when prompted.
Step 3
Press the “Windows” key, and then type “%appdata%” and then you have to press “Enter” in case to open a folder that contains itunes application data. After that navigate to “Apple Computer\MobileSync\Backup” and then enter the directory with the most recent date in the Date Modified section.
Step 4
You have to choose the file “3d0d7e5fb2ce288813306e4d463695e047a3d38” and then press “Ctrl C” to copy it. Navigate to the “sqlite3” folder in your root directory and then press “Ctrl V” in case to paste the SMS database file there. Click the file, and then press “F2” and you can rename it “sms”.
Step 5
Press “Window” key and then type “cmd” and press “Enter” to open a Command Prompt window. Enter the following commands in the console, and then press “Enter” after every line: cd c:\sqlite3.exe sms .outpu iphonesms.txt select * from message; .exit. Your message will appear in the file “iphonesms.txt” in the “sqlite3” folder.
Trend Message 