4

I was working on SQLite database and need to convert it to a .db extension instead of having data.sqlite. My client needs the data in data.db extension. So is there any way to convert the data.sqlite file into data.db file?

Jahan Ahmed Abbasi
  • 89
  • 1
  • 11
  • 1
    See this question: https://stackoverflow.com/questions/5847067/what-is-difference-between-sqlite-and-db-file – McGlothlin Jul 03 '17 at 23:46

1 Answers1

7

The name of your file is completely irrelevant to the data inside of it. Assuming the data structure is properly setup, simply renaming the file will suffice.

Note: If you're running windows, you will need to enable file extension visibility.

Jacobm001
  • 4,431
  • 4
  • 30
  • 51
  • so what you are saying is if I rename the database to some meaningful name and than rename the database file with db extension it I will get convereted database? – Jahan Ahmed Abbasi Jul 03 '17 at 23:52
  • No. Jacob is saying that you've only asked for a particular name. Renaming the file will result in an SQLite database with a different name. If you really want it converted to another format you should ask about _that_ instead of asking about the name. – ChrisGPT was on strike Jul 03 '17 at 23:55
  • It was so silly of me, I just rename the database from data.sqlite to data.db and it is working. – Jahan Ahmed Abbasi Jul 03 '17 at 23:55
  • 2
    Thanks for your answer and comment I really appreciate it. I was only trying to change the extension of the file. – Jahan Ahmed Abbasi Jul 03 '17 at 23:57