convert a .sql file to a .db file

[kevnm67]

Hey everyone!

I'm new to sql and having trouble figuring out how can I convert my .sql
file to a .db file?

I originally had the database made by someone who ran a python script on my
.csv file and parsed the info into a .db file. Running this script has been
inconsistent for me - yesterday AM it worked but late afternoon it did not.
I'd rather use a GUI for SQLite to deal with the database ….unless y'all
have some suggestions?

The database is for my iOS application.

Thanks for any help y'all can provide!

Kevin



--
View this message in context: http://sqlite.1065341.n5.nabble.com/convert-a-sql-file-to-a-db-file-tp66516.html
Sent from the SQLite mailing list archive at Nabble.com.

[Simon Slavin]

Post by kevnm67
I'm new to sql and having trouble figuring out how can I convert my .sql
file to a .db file?

Use a SQLite tool to dump to .csv format, then use a DB tool to import the .csv to DB format. Since this is a SQLite list, we can help with a good SQLite tool:

http://www.sqlite.org/sqlite.html

You might want ".mode csv".

Simon.

[kevnm67]

Thanks Simon! Ill try that out.




--
View this message in context: http://sqlite.1065341.n5.nabble.com/convert-a-sql-file-to-a-db-file-tp66516p66521.html
Sent from the SQLite mailing list archive at Nabble.com.