How to import .sql to .sqlite in mac [closed]

Question

Can anyone let me know how we can convert .sql database file into .sqlite file in mac.

Thanks in advance.

Answer 1

The way this is done depends on your DBMS, however generally speaking there are the following steps:

1. Create a Dump File out of your SQL-Database. A dump file contains all sql-statements needed to recreate that same SQL-Database on another machine.
2. Check if your source DBMS does contain SQL-Syntax not supported in SQLite. The documentation for SQLite https://sqlite.org/lang.html is the main source for this task. Notepad++ or other text editors are a helpful tool here. Also the moment you try to read in your MySQL-Dump in SQLite you will get an error traceback highlighting not supported keywords.
3. Craft the SQL-Dump so that it only contains SQL-Statements supported by SQLite.

Note that crafting portable SQL is a very hard and time consuming task and you might loose some functions compared to the source database.