PureBasic Forums - English

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.

Use sql attach database and select all rows within an insert statement.
Do not select rowid, else that exists in 1st db.

Which database

SQLite
PostgreSQL
MariaDB
if ODBC which database is behind ...