Convert SQLite to PSQL online
Input file
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
Output file
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.
Conversion methods
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
How long does it take?
For small databases, the conversion process usually takes only seconds or a few minutes. For big databases, the process might be significantly longer.
Which softwares are using SQLite databases?
- For example the iPhone uses the AddressBook.sqlitedb and AddressBookImages.sqlitedb files for the contacts.
You can also use your favourite tool
Why use RebaseData?
- Strong security.
- Convert online without installing SQLite yourself.
- Works with Windows, Mac and Linux.
- Use an API to convert your databases.
- Professional support.
Terms
- We don't guarantee for the success or correctness of the conversion
- You are only allowed to convert your own database files
- By using RebaseData, you agree to our general terms