Convert SQL to POR

Turn SQL files into POR files. An SPSS portable file in ASCII.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Tables from a SQL script as SPSS files.Each table the script creates becomes its own POR file, with numbers and dates typed.

  1. What you get

    An SPSS portable file in ASCII for each table the script creates. Each file is named after its table, and the files come in name order.

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect first, so those dumps convert as they are.

  2. How values are converted

    Integers and decimals become numbers. Columns declared DATE, DATETIME or TIMESTAMP become dates and date-times. Text columns stay text, even when they hold dates.

    Binary values become escaped text, and NULL becomes system-missing. Dates that are not real dates, such as MySQL's 0000-00-00, become missing. PostgreSQL true and false become 1 and 0.

  3. What changes or is left out

    Views, functions and triggers are left out with a warning. Only tables are converted.

    Column names become SPSS names of up to 8 capital letters, digits and underscores. When a name changes, the original is kept as the variable label.

    Dates are written as DATE11, date-times as DATETIME20 and times as TIME8. Characters outside ASCII become ?, and text longer than 255 characters is cut.

SQL and POR.What each format is.

The formats

From · 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
To · POR

SPSS Portable

SPSS portable files, the plain-text exchange format of older SPSS versions and PSPP.

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

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

terminal
$ cv convert report.sql report/ --to por
$ cv convert report.sql report/ --to por

Questions.What people ask about SQL to POR.

01OF 04

No. You get one file for each table the script creates, named after the table. A script with several tables gives several files. See every SQL conversion for other targets.

Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect first, then converted.

They become SPSS names of up to 8 capital letters, digits and underscores. If a name changes, the original is kept as the variable label.

No. Characters outside ASCII become ?. Text longer than 255 characters is also cut.

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