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.

  1. 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.

  2. How values are written

    Binary values are written as hex, so the script stays text. The rows keep their values from the database.

  3. 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

From · SQLITE

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
To · SQL

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.

terminal
$ cv convert report.sqlite report.sql
$ cv convert report.sqlite report.sql

Questions.What people ask about SQLITE to SQL.

01OF 04

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.

More conversions.Other ways in and out of SQLITE and SQL.