How to read a .db file, is it an SQLite database?
Solved
ajp55
Posted messages
482
Status
Membre
-
ajp55 Posted messages 482 Status Membre -
ajp55 Posted messages 482 Status Membre -
Hello
I want to read the database, and the file extension is .db (it's the database file of the VCE software). I would like to extract the data from this software for other uses. In my version of VCE, I can access the database and even extract it; it's a .db file,
but I don't yet know the type of database nor the language used and the tables involved.
I assumed that it's a SQLite file and tried to write a Java program to read this file. I know how to add the libraries (JDBC) to communicate with databases.
But it doesn't work, and I'm wondering if my assumptions are wrong, if it's not a SQLite file, and how to display the structure of the database because SHOW TABLES doesn’t work.
Thank you in advance for any response.
--
"The computer is a great invention: there are as many mistakes as before, but no one is responsible anymore..."
I want to read the database, and the file extension is .db (it's the database file of the VCE software). I would like to extract the data from this software for other uses. In my version of VCE, I can access the database and even extract it; it's a .db file,
but I don't yet know the type of database nor the language used and the tables involved.
I assumed that it's a SQLite file and tried to write a Java program to read this file. I know how to add the libraries (JDBC) to communicate with databases.
But it doesn't work, and I'm wondering if my assumptions are wrong, if it's not a SQLite file, and how to display the structure of the database because SHOW TABLES doesn’t work.
Thank you in advance for any response.
--
"The computer is a great invention: there are as many mistakes as before, but no one is responsible anymore..."
In my version of VCE, I can access the database and even extract it, it’s a .db file, what format did you extract it to, because a .db is generally "openable" with Excel?