Convert SQLITE to SAV

Turn SQLITE files into SAV files. An SPSS file in UTF-8.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

Every table in its own SAV file.Each table in the database becomes one SPSS file in UTF-8.

  1. What you get

    One SAV file per table, named after the table. The files come out in table name order. Views are skipped, so only real tables are written.

    Integers and reals become numbers. Columns declared DATE or TIMESTAMP become dates and date-times. NULL becomes system-missing.

  2. What changes on the way

    Text columns stay text, even when they hold dates. Only columns declared DATE or TIMESTAMP become dates. Dates are written as DATE11, date-times as DATETIME20 and times as TIME8.

    Blobs become escaped text. A table with text stored in a number column is written as text.

    Column names become SPSS names of up to 64 bytes. When a name changes, the original is kept as the variable label. Text longer than 32,767 bytes is cut.

  3. Going back

    To turn an SPSS file into a database again, use SAV to SQLITE.

SQLITE and SAV.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 · SAV

SPSS Data

SPSS data files with variable labels and value labels.

Extensions
.sav .zsav
MIME type
application/x-spss-sav
Kind
Text and data

In your code.The same SQLITE to SAV conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to sav
$ cv convert report.sqlite report/ --to sav

Questions.What people ask about SQLITE to SAV.

01OF 04

Yes. Each table is written to one SAV file named after it. Views are skipped.

Only columns declared DATE or TIMESTAMP become dates. A text column stays text even when it holds dates.

NULL becomes system-missing in the SAV file.

Column names become SPSS names of up to 64 bytes. If a name changes, the original is kept as the variable label.

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