Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a series of .db3 files in my computer. They are like filename1.db3, filename2.db3, filename3.db3, filename4.db3 and so on.

I can open filename1.db3 with sqlite editor. But when I open filename2.db3 file with sqlite editor, the sqlite editor gave me error like "It is not correct format".

What program should I use to open all of those .db3 files together? Thanks in advance.

share|improve this question
up vote 6 down vote accepted

In theory you should know where the file came from and ask the person who gave it to you. A file extension could mean anything. In the old days, .db3 extension used to be for dBase III data files. It also could be for SQLLite binary dump file. See for example Importing SQLite db3 files. If you have problems, it may be attributed to many factors, version compatibility may be one of them. You may also want to perform an integrity check as in here:Pragma Check.

share|improve this answer

Just try using the SQLiteSpy application. Through that you can easily view and analyze all .db3 files.

share|improve this answer
Is it much different from SQLite Editor the OP mentioned? – dezso Dec 16 '12 at 15:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.