Our API accepts a single *.SQLITE, *.SQLITE3, *.SQLITEDB or *.DB file as input. Files with these extensions are usually SQLite database file.
Additionally, it's possible to specify a SQLite-WAL-file, in case you use Write-Ahead logging.
Max file size for web uploads: 50 GB
The API will return a ZIP archive that contains a .SQL file. This .SQL is a PostgreSQL dump file and can be restored into your PostgreSQL installation.
Download the RebaseData client Java tool . To convert your database using RebaseData, run the following command:
java -jar client-0.0.5.jar convert --output-format=postgresql file output-dir/
Replace file with the path to the *.SQLITE, *.SQLITE3, *.SQLITEDB or *.DB file you want to convert.
The file output.zip will contain a PostgreSQL data.sql file with your data or the error message if something went wrong.
curl -F 'files=@file' 'https://www.rebasedata.com/api/v1/convert?outputFormat=postgresql&errorResponse=zip' -o output.zip
For small databases, the conversion process usually takes only seconds or a few minutes. For big databases, the process might be significantly longer.