SQLite Forum

Copy *.sqlite database to *.db3 database

Copy *.sqlite database to *.db3 database

(1) By JBH630 (jbhsolutionslm) on 2020-11-09 14:24:41 [source]

I recently updated my apps to the latest SQLite app. The extensions on the files are now ".db3". My previous files have the extension ".sqlite". How can I copy the data from the .sqlite database to the new .db3 database?

(2) By Larry Brasfield (LarryBrasfield) on 2020-11-09 15:02:44 in reply to 1 [link] [source]

There are several ways to do what you ask.

You can open your DB with the SQLite command line shell, then use its .backup commend to write it out with whatever name you like. (Type '.help backup' in that shell to see how.)

If no process has the DB open, you can use the usual OS file copy methods to copy the original DB file to one named as you like.

Many more ways can be imagined. These are the easiest, IMO.

(3) By JayKreibich (jkreibich) on 2020-11-09 15:19:05 in reply to 1 [link] [source]

There is no official file extension for SQLite database files, so people tend to use what makes sense to them. They're the same files with the same file formats. You can just copy/rename the file.