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.

No comments: