Merge Combine SMS Database of two iPhone iPad

How to merge SMS of two iPhone, transfer only SMS from old iPhone to new iPhone and how to combine SMS text msgs of two iPhone without restoring iPhone.


                       Here I will explain few ideas about how to transfer only SMS, text messages from iPhone to another iPhone / iPad. Or how to merge SMS of two different iPhones / iPad without restoring iPhone or restoring iPad. For iPad/ iPhone SMS merging without using any software, you need good knowledge of SQL database. 


Why you need to merge combine sms, text messages, iMessages of two different iPhone.


                  You have bought new iPhone and you started using new iPhone. After 2 months you realize that you forgot to transfer old iPhone messages, sms, MMS, iMessages and other data to new iPhone. Now a days SMS are stored on iPhone messaging app and not on sim card.

                         Iphone iPad has built in messaging application. Imessages is mainly used when you are sending messages to another iPhone. This is built in apple instant messaging application. All SMS text messages are stored under this application. This app use SQL database to store and index all your mms, sms text messages data.

Before continue to

 this manual way to combine sms of two iPhone and merge SMS of two different iPad. I provide you one trick for SMS merging.


                         Someone suggest me this tricks. It says that you can merge sms of two different iPhone by this method without restoring iPhone. This method better work for Mac computer and you can try for windows computer also. Before you try this tricks I suggest to take backup of both iPhone. If anything goes wrong, we can restore original data on iPhone.

-          Open apple menu on MAC computer -then go to system preference on apple menu – click on iCloud – Login with apple id and make sure you keep same apple id for both iPhones. That means your both iPhone are listed under single apple user id.

      -           Select service like messages on iCloud.


      -          Now restore new iphone from old iPhone backup. On new iPhone, you have transferred SMS text messages, iMessages and all data from old iPhone.

     -           You need to merge sms of new iPhone that are on iCloud to new iPhone.


     -          It is said that messages are kept by Your account.

    -          Keep connected with internet. Go to iCloud setting and turn off text messages.
    -          This will display notification that your SMS text messages are kept on iPhone now.

    -          Again turn on text messages SMS on iCloud setting of new iphone. On which you have restore backup of old iPhone. This will merge SMS text messages of iCloud and iPhone.

                                             Do comment me, does it really merge the SMS of two different iPhone or not. Does this SMS merging tricks works on windows computer or not. By iCloud you can merge contact, calendar and media information into one iTunes library. And you can sync new iPhone from this iTunes library.

                               You can try both SMS merging method for merging MMS, iMessages, SMS of iphone5, iPhone 12, iPhone 11 with sms, mms and imessages of iphone6, iPhone XS, iPhone plus, iPad and iPhone se. you can also merge combine SMS, MMS, iMessages of iPad pro, iPad air, iPad mini with sms of iPad pro, iPad air, iPad mini and iPhone. Here is the way  to transfer iPhone sms database to another iPhone iPad without merging. This method require to restore iPhone /iPad.


How to merge SMS text messages of two iPhone /iPad without software and how to combine iMessages of two iPhones / iPad from SQL database without restoring .





                Location of mms,sms, text messages  stored on iPhone and location of imessages on iPhone iPad are

-Private /var / mobile / library / sms/. And under this sms folder find sms.db file this is your SMS database file stored at iPhone / iPad using SQL. This is the common location of sms text messages stored on iOS devices.

                            On OS X system iMessages, sms and text messages are stored under folder library / messages. This sms, iMessages are stored with SQL database.

On windows computer and mac computer location of iPhone backup data.

                   On windows computer there are user / admin or username / appdata / roaming / apple computer /mobilesync / backup. There is a sms,mms, imessages and text messages  are also backup  under this backup file.

                     On different windows operating system like windows 10, windows8, windows7, windows vista ,xp, location of backup file is different. So simple way to find location of backup file on all windows operating system, is find application data folder by typing %appdata% at run command prompt. This will open new window - under that folder find apple computer folder- insider that apple computer folder -your iPhone backup is stored.

On mac computer find the library/ application support / mobilesync / backup.

                            Itunes create unique id file name for each backup of apple device. And there is a separate folder for each apple devices which are backed up by iTunes. Each backup file has long file name having number and character. This backup file have extension of meta data /.mddata or .mdbackup.

                             You can find many free tools which can open this backup file and sms.db file. From which you can export SMS into pdf or word file. Now export first iPhone sms to pdf file and also export sms of second iPhone to pdf. Merge those pdf file and copy that sms file to new iPhone. So you can at least have both iPhone sms on one iPhone.


                                   Now import sms.db files from both iPhone or iPad. These are the sms, imessages database file of both iphones.

Here are the main files for sms merging. You can find these files at var/ mobile / library /sms/. You must take ownership of each file for merging tempering those files.

1) sms-legacy.db

2) sms.db               -  this is actual sms database on iphone. It has following data table
Sqllite3 Database property,
msg group,
group member,
 msg piece and
message – your actual text messages are stored at this data table.

There are many tools which can read and open sms.db file. Which can be understood by human.

3) sms.db-shm and sms.db-wal.          This two file used for indexing many sms, mms. They can be easily accessible and for searching the sms. If you enter the sim mobile number, it will index the all sms from that number.
Sms.db-shm is temporary file created by sqllite.  Sms.db-wal is write ahead log file which is created by SQL.

4) Attachment folder. This kept all the attachment for all sms, mms and iMessages.
5) Draft folder.


                     In sms.db file has data table. Now if you have same iOS on both iPhone. Then both the sms.db file has same data table. There are sqllite program, which can import data table from one db file to another. Here you import data table from one iPhone sms.db file to another. Even there are many SQL program tool, which can merge database of multiple files into single database file. You can merge two sms.db file by using sql command for merging two databases into single database. That is sms.db file of iPhone and sms.db file of another iPhone.  So just find command for sqllite3 for copy one database to another database or merging two databases into single database. There are also many free scripts available for merging two databases into single database.

                     Once you created merged sms.db file sync iPhone with iTunes or iCloud with this file.  Restore iPhone with this merged sms file.

IPhone SMS Transfer to iPhone iPad

Transfer sms messages from one iPhone to another iPhone, copy text message mms, iMessages, data between two iPhones and how to transfer sms text msgs from old iPad to new iPad.


Iphone sms (Short Message Service) transferring can be done by two ways. 

First method: How to transfer SMS iPhone to iPhone.


You take back up of old iPhone to computer by iTunes,iCloud, Dropbox or any cloud storage. Then you can restore new iPhone with old iPhone's back up. In this method you can transfer SMS from iPhone to another iPhone. This will erase all data of new iPhone. Many time it happen that you bought new iPhone and started to use it. After one month you realize that, you want to combine SMS, mms, imessages and text messages of old iPhone to new iPhone. As it is not possible that you carry both iPhone with you. In this method you transfer all of iPhone data to another iPhone.

Second method: How to Merge SMS of two iPhone to one iPhone. 

 
 You combine SMS of two iPhone to one iPhone without restoring iPhone. This method is used when you want to transfer only sms, text messages between two iPhone. Or you want to copy only SMS text messages from one iPhone to another iPhone.  I have created separate post for how to merge combine sms, text messages of two different iphone / ipad. By that method you can transfer only sms text messages from one iPhone to another iPhone. Or you can move sms mms from old iPad to another new iPad.


Steps for how to transfer sms from iPhone to another iPhone.

 
 How to move sms text messages of old iPad to new iPad.

                 This method is  applicable for transferring sms text messages from iPhone 12, iPhone XS, iPhone 11  to iPhone PLUS, iPhone 13, iPhone se and iPhone 6s plus. You can also use for copying sms from iPad pro, iPad air, iPad mini to iPad pro, iPad air, iPad mini.

Step 1. Connect your old one iPhone to computer. IPhone should appear in this PC or my computer.

Step 2. Open iTunes. Itunes found iPhone in device tab.

Step 3. On left hand side column of iTunes – select the old iPhone from which you want to move sms, text messages, mms and data to new iPhone.

Step 4.  Now you will make back up of iPhone. You can make backup of iPhone by iTunes and iCloud.

-To take iPhone backup by iCloud: 

 
You need to connect iPhone to WiFi internet.
-Once iPhone connected to internet.  Unlock iPhone screen.
- Tap on iPhone setting- tap on iCloud – turn on iCloud backup- then tap on backup now.

After completion of backup, iPhone backup will appear in storage – manage device –device name your iPhone name.

Take iPhone back up by iTunes:


-As you have connected iPhone to computer and you have opened iTunes - on left hand side you will find iPhone and all connected iOS devices. Select iPhone from which you want to copy SMS to another iPhone.

-  Click on summary tab. On right hand side, you will find the options as show in below image. Automatically backup on this computer, icloud and manual backup and restore. It also shows that when you have last backed up iPhone.




IPHONE SMS TRANSFER TO IPHONE

- Click on backup now.
- you will find all your back up of iTunes here- open iTunes – click on edit menu – click on preferences – click on device tab – this will provide you the list of all back up on computer iTunes library.

Merge two iPhone SMS to one iPhone

Step 5. Now connect another iPhone on which you want to transfer SMS text messages from iPhone.

 Step 6. Open iTunes.  Select the new iPhone on which you are moving SMS, mms from old iPhone.

Step 7.  Click on summary tab. Now  click on restore backup. Or right click on new iPhone on which you are transferring SMS from another iPhone. Then select restore from back up.

Step 8. This will provide the list of backup.  You should select backup of old iPhone and restore the new iPhone with old iPhone backup. This will restore contact, calendar, notes, text messages and setting on new iPhone. Keep in mind, this will not restore firmware.
 This will wipe out all data on new iPhone.

Step 9. It will take few minute to restore iPhone. Keep iPhone connected to computer until it restarts and sync with computer.

Step 10. Disconnect your iPhone from computer and check the messaging app. You will successfully transferred SMS to iPhone.