Your thoughts... on the Best way (command to use) for migrating to postgresql on new windows server from sqlite

General
1

Hello looking for the preferred way to migrate from a windows server using sqllite to a new windows server using postgresql i see multilple different recommandations and commands to replicate or move the data what is the best way that you all have experienced this with.

we have a 4tb imaging storage that is hosted on azure fileshare

this is a shared storage so can mount this storage to both servers if it is helpful in this transfer.

we are using the storage directory option in the orthanc.json config file

i have the new server ready with current release of Orthanc and postgresql

i see that there are a few options to do this.

would the replicate option be the best solution for this scenerio

python Replicate.py 0.0.0.0:8042 0.0.0.0:8042

Thanks for any help,

2

Hi,

You basically need to spin a new Orthanc instance, listening to different ports with a new empty storage folder and then, you can use replicate.py or ImportDicomFiles.py.
Then, once your migration is complete, you can stop the old Orthanc and switch the ports.

However, if you want to avoid down time and continue receiving files while migrating, you should use the OrhtancCloner scripts from this python package. Sorry, the doc is not great (but the code is available :wink: ).

HTH,

Alain.