Hello there!
i have two database files with the same structure and i would like to merge them into a new database file. How can i achieve that? I was thinking to create an empty database with exactly the same tables and indexes and then import the data from the other 2 databases by .export csv & .import csv to table. Since i haven't much knowledge about SQL i already read a bit about it and studied the structure of the databases with a database viewer. Would you recommend doing this by CSV import functions?
Greetings
A.D.
merging two database files into a new one
merging two database files into a new one
Repeat
PureBasic
ForEver
PureBasic
ForEver
Re: merging two database files into a new one
Use sql attach database and select all rows within an insert statement.
Do not select rowid, else that exists in 1st db.
Do not select rowid, else that exists in 1st db.
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum
Re: merging two database files into a new one
Which database
SQLite
PostgreSQL
MariaDB
if ODBC which database is behind ...
SQLite
PostgreSQL
MariaDB
if ODBC which database is behind ...