# Sqlite backend to postgreSQl

**URL:** https://discourse.orthanc-server.org/t/sqlite-backend-to-postgresql/2721
**Category:** Google Groups archive
**Created:** [November 29, 2021, 10:44am UTC](https://discourse.orthanc-server.org/t/sqlite-backend-to-postgresql/2721 "2021-11-29T10:44:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![maaak770](https://discourse.orthanc-server.org/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@maaak770](https://discourse.orthanc-server.org/u/maaak770)
#### Post date: [November 29, 2021, 10:44am UTC](https://discourse.orthanc-server.org/t/sqlite-backend-to-postgresql/2721/1 "2021-11-29T10:44:34Z")

</div>

currently I am using SQlite backend and have more then 200gb of dicom files and around 100000 of instanced, how to move all of this from sqlite database to postgresql db is there?

---

<div class="post-metadata">

### Author: ![maaak770](https://discourse.orthanc-server.org/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@maaak770](https://discourse.orthanc-server.org/u/maaak770)
#### Post date: [November 29, 2021, 10:46am UTC](https://discourse.orthanc-server.org/t/sqlite-backend-to-postgresql/2721/2 "2021-11-29T10:46:07Z")

</div>

my orthanc server is running on windows.

في Monday, November 29, 2021 في تمام الساعة 1:44:34 PM UTC+3، كتب ‪mohammed alkh‬‏ رسالة نصها:

---

<div class="post-metadata">

### Author: ![Alain\_Mazy1](https://discourse.orthanc-server.org/letter_avatar_proxy/v4/letter/a/839c29/32.png) [@Alain\_Mazy1](https://discourse.orthanc-server.org/u/Alain_Mazy1)
#### Post date: [December 1, 2021, 8:04am UTC](https://discourse.orthanc-server.org/t/sqlite-backend-to-postgresql/2721/3 "2021-12-01T08:04:04Z")

</div>

Hi,

There’s no real upgrade procedure from SQLite to Postgres. You should actually:

- stop Orthanc SQLite
- copy your storage folder to another location
- start Orthanc Postgres,
- run this script to import your old storage folder: [https://book.orthanc-server.com/users/replication.html#direct-access-to-the-filesystem](https://book.orthanc-server.com/users/replication.html#direct-access-to-the-filesystem)

HTH,

Alain
