Skip to main content

duckdb-upgrade

Tests

A tool to easily upgrade duckdb databases from one version to another. It automates the process of exporting the contents of a DuckDB database and then importing them into a newer version of a DuckDB database.

[!IMPORTANT] This process isn't guaranteed to be compatible with every combination of DuckDB. The tool is limited to forward upgrades only, but things may still break during that upgrade. By default this tool keeps a backup of the old version of the database, but it is still important to be mindful of any process that may cause data corruption. Any data loss or corruption is on you, so exercise reasonable precautions before use.

Usage

This tool is available both through pip and Docker. Use one of the following commands to run it, or your preferred method to run Python packages or Docker images. These examples cover upgrading some DuckDB in the current directory to the latest version of the database.

via Pipx

$ pipx run duckdb-upgrade example.duckdb

via Docker

$ docker run -v $(pwd):/data ghcr.io/mrflynn/duckdb-upgrade:latest /data/example.duckdb

Advanced Usage

You can also specify the target version you with to upgrade to using the -t flag. For example, if you wish to upgrade some database to version 0.10.0, run the command as follows:

$ duckdb-upgrade -t '0.10.0' example.duckdb

[!CAUTION] You can also run the tool with the --no-backup flag which won't create a backup of the original database before upgrading it. This is potentially dangerous, so please use with caution. Again, any data loss resulting from this is on you.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

duckdb_upgrade-0.16.0.tar.gz (5.4 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

duckdb_upgrade-0.16.0-py3-none-any.whl (7.5 kB view details)

Uploaded Python 3

File details

Details for the file duckdb_upgrade-0.16.0.tar.gz.

File metadata

  • Download URL: duckdb_upgrade-0.16.0.tar.gz
  • Upload date:
  • Size: 5.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for duckdb_upgrade-0.16.0.tar.gz
Algorithm Hash digest
SHA256 e260071c51462edf2cb861628b61c2d7caf41a3c1492f527aaca6816988bf318
MD5 a39a8d5c87372c7b6cea9b2246998faa
BLAKE2b-256 ba3fe61cef32cfe3642b921b1988fd62e33c47bab7ec5d3ef16ab7dd810e2c11

See more details on using hashes here.

Provenance

The following attestation bundles were made for duckdb_upgrade-0.16.0.tar.gz:

Publisher: release.yaml on MrFlynn/duckdb-upgrade

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file duckdb_upgrade-0.16.0-py3-none-any.whl.

File metadata

File hashes

Hashes for duckdb_upgrade-0.16.0-py3-none-any.whl
Algorithm Hash digest
SHA256 0da244cd85953ceb1b960894f6263e9093caaca068b21d9f1045ef714269e154
MD5 c8899682b5960310e71a2241556faf06
BLAKE2b-256 68f2ebb1022cb4da586b9d777a7263ddacc743792b526515c60eddc73ab6d7e3

See more details on using hashes here.

Provenance

The following attestation bundles were made for duckdb_upgrade-0.16.0-py3-none-any.whl:

Publisher: release.yaml on MrFlynn/duckdb-upgrade

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

0.16.0 This release

2 files

0.15.0

2 files

0.14.0

2 files

0.13.0

2 files

0.12.0

2 files

0.11.0

2 files

0.10.0

2 files

0.9.0

2 files

0.8.0

2 files

0.7.0

2 files

0.6.0

2 files

0.5.0

2 files

0.4.0

2 files

0.3.0

2 files

0.2.1

2 files

0.2.0

2 files

0.1.1

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page