I am working on a Qt project with sqlite database. I just want to merge two databases (*.db file) with same schema using QSqlDatabase code. what is the best way to do this?
Thanks
Asked
Active
Viewed 124 times
0
-
Maybe just read all data from db1 to db2 for each table for each row? – Deep Jul 16 '18 at 07:44
-
Attach the second database to the first and use insert queries to merge the data. – drescherjm Jul 16 '18 at 14:27
-
@Deep it is the last method I want to use. I'm looking for the easiest method. – Behzad Jul 17 '18 at 05:32
-
@drescherjm Do you mean this https://stackoverflow.com/questions/80801/how-can-i-merge-many-sqlite-databases – Behzad Jul 17 '18 at 05:34
-
It is normal flexible method with full control. Depend on DB it can be simplified, e.g. insert select or append dump. – Deep Jul 17 '18 at 08:56