CODEWITHSUNDEEP
databasesqlite
Dennie
Dennie

Reputation: 2651

Copy records from two database in sqlite

How can I copy records from two Database, "db1.db" and "db2.db" with different column structure?

Upvotes: 1

Views: 390

Answers (1)

Chris Ballance
Chris Ballance

Reputation: 34347

This will have to be done a table at a time, not a database at the time.

Since you mention the schema is different between source and destination, you will have to normalize this before making a copy. Most automated tools you might use will probably require the same schema to automate this process, or require you to map source columns to destination columns.

Upvotes: 1

Related Questions