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.
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.
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.
Going back
To turn an SPSS file into a database again, use SAV to SQLITE.
SQLITE and SAV.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
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.
$ cv convert report.sqlite report/ --to sav$ cv convert report.sqlite report/ --to savQuestions.What people ask about SQLITE to SAV.
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.