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.
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.
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.
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
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
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.
$ cv convert report.sql report/ --to por$ cv convert report.sql report/ --to porQuestions.What people ask about SQL to POR.
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.