Convert SQLITE to SQL
Turn SQLITE files into SQL. The SQL statements that rebuild every table, index, view and trigger with all their rows, binary values written as hex.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SQLITE files on the dialor turn it to pick what to do
A SQLite database as plain SQL text.One script that rebuilds every table, index, view and trigger.
What you get
A single SQL file with the statements that rebuild the whole database. Every table, index, view and trigger is in it, and every table comes with all its rows.
Any SQL tool can read the script, and you can replay it to recreate the database. It is also plain text, so you can open it and read it.
How values are written
Binary values are written as hex, so the script stays text. The rows keep their values from the database.
Damaged databases
A damaged database is refused rather than dumped in part. If the file cannot be parsed, the conversion stops with
input_corrupted, and no partial script is produced.To go the other way, use SQL to SQLITE.
SQLITE and SQL.What each format is.
The formats
SQLite Database
A whole relational database in one file. Tables, indexes and views.
- Extensions
- .sqlite .sqlite3 .db
- MIME type
- application
/vnd .sqlite3 - Kind
- Text and data
SQL Script
SQL statements as text. A database dump that any SQL tool can read or replay.
- Extensions
- .sql
- MIME type
- application
/sql - Kind
- Text and data
In your code.The same SQLITE to SQL conversion through the API, for your app or your agent.
$ cv convert report.sqlite report.sql$ cv convert report.sqlite report.sqlQuestions.What people ask about SQLITE to SQL.
It includes both. Tables, indexes, views and triggers are rebuilt, and every table comes with all its rows.
They are written as hex. This keeps the whole script as text.
The conversion is refused instead of dumping part of the database. It stops with input_corrupted when the file cannot be parsed.
Files ending in sqlite, sqlite3 or db are accepted as a SQLite database. The result is one file ending in sql.