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.
