K
K
Konstantin2015-10-17 22:00:39
MySQL
Konstantin, 2015-10-17 22:00:39

How to create a .db file from a .sql file?

Good afternoon!
There is a site backup in .sql format, you need to convert the file to .db format to work in SID (SQL Interactive Demonstrator). Can you please tell me how this can be done?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Ruslan Fedoseev, 2015-10-17
@KoNnY

the db format is very vague.
What database does your SID work with?

S
Stanislav Makarov, 2015-10-17
@Nipheris

Let's agree to talk about the sqlite format, since we already found out in the comments.
So, download the command-line shell from here: sqlite.org/download.html
Run it, specifying the name of the new database file as a parameter, for example sqlite3 demo.db (example here ).
Then you insert and execute all SQL statements one by one. Everything will be written to the file you specified.
If you really want a GUI, then SQLiteStudio is what I usually recommend. There you will also need to connect a new database, and execute all your SQL constructs in it.
However, Ruslan Fedoseev gave a much more convenient option than throwing at one request))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question