For tables with large data volumes, cross-Library replication is required, and data table migrations of SQLite database across databases are implemented using NAVCAT [reprint]

December 13, 2014 14:36 Sina blog

(Transferred from Http://www.cnblogs.com/nmj1986/archive/2012/09/17/2688827.html)

Demand:

There are two different SQLite databases A, B, you need to copy the table in the B database to a database, when the amount of data is small, you can direct the table into a. sql file in the database visualizer Navicat, and then run the SQL file in another database. However, when the amount of data is large, this operation loses some of the data. Therefore, the following methods can be used for this situation:

Workaround:

(1) Using the software: SQLite Expert Personal 3;

(2) Operation procedure:

A) open a, B database in software SQLite Expert Personal 3;

b) Select a database, click the right mouse button, find the "Attach database" option, select the execution;

c) in the pop-up "File Selection" screen, select the B database file, click the "Confirm" button;

d) In the dialog box that pops up, first verify that the database file you selected is correct. If correct, click on the "OK" button;

(3) Execute SQL statement:

INSERT INTO A. Table 1 Select * from B. Table 1 Note: The prerequisite is to create a table with the same format in advance, A is generally written in main other database methods similar (MySQL Oracle, etc.) example

INSERT INTO Main.landuse select * from Mydbb.landuse   // import landuse tables from MYDBB database into a database

For tables with large data volumes, cross-Library replication is required, and data table migrations of SQLite database across databases are implemented using NAVCAT [reprint]