how to copy all tables in sqlite's database from one database to another using c++ [duplicate]

Question

please help me for: how to copy all tables in sqlite's database from one database to another using c++

I have a database file,I want to copy all table to another database and using c++ language,I don't know how to Loop read all table in the original database an how to copy them to another database using c++.

Does this answer your question? Copying data from one SQLite database to another — Vlam
– Vlam, Commented Dec 20, 2019 at 2:07

MikeT · Accepted Answer · 2019-12-20 03:32:04Z

0

You can just create a copy of the database file with the new database name, that is assuming you want all the data as well. This can be done without connecting to/opening the database by standard File handling.

The database name is only significant as the file name.

Another way is to use VACUUM INTO 'file'; again this copies all data, this does require the database to have been connected as the above is an SQL statement.

e.g. VACUUM INTO 'E:\Navicat\SQlite Databases\myOtherDBName'; (Windows)
see VACUUM

If you don't want the data then when connected to the new database you can delete the rows in all the tables followed by a VACUUM (if you wish). This would probably be best done within a transaction.

edited Dec 20, 2019 at 3:32

answered Dec 20, 2019 at 3:14

MikeT

57.9k16 gold badges61 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Cheetah Over a year ago

But I need using c++ to finish it

MikeT Over a year ago

@JiangKai either can be done in c++ (or many languages).

Collectives™ on Stack Overflow

how to copy all tables in sqlite's database from one database to another using c++ [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related