# How to migrate only the Users from Rel 16 to Release 20

**URL:** <https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806>\
**Category:** usegalaxy.org support\
**Tags:** devops-administration\
**Created:** [April 2, 2022, 1:33am UTC](https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806 "2022-04-02T01:33:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![george.weingart](https://sea2.discourse-cdn.com/flex020/user_avatar/help.galaxyproject.org/george.weingart/32/1770_2.png) [@george.weingart](https://help.galaxyproject.org/u/george.weingart)\
**Post date:** [April 2, 2022, 1:33am UTC](https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806/1 "2022-04-02T01:33:34Z")

</div>

Hi,  
We are planning our upgrade of Galaxy from Rel.16 to Rel 20.  
Our Production Galaxy is quite big (More than 8,000) Users.  
One of the paths that we are considering is to migrate only the Users and start with clean data.  
Can anyone provide us a script to copy the necessary tables to achieve that ?  
Thank you !  
George Weingart PhD  
Huttenhower Lab  
Harvard School of Public Health

---

<div class="post-metadata">

**Author:** ![george.weingart](https://sea2.discourse-cdn.com/flex020/user_avatar/help.galaxyproject.org/george.weingart/32/1770_2.png) [@george.weingart](https://help.galaxyproject.org/u/george.weingart)\
**Post date:** [April 15, 2022, 4:00am UTC](https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806/2 "2022-04-15T04:00:01Z")

</div>

Hello,  
I posted this question 13 days ago and have received no replies.  
Can someone from the Galaxy Support team please address the issue or can someone let me know where should I post the question or how to contact someone in the Galaxy Support Team to discuss ?  
Thanks  
George Weingart PhD  
Huttenhower Lab  
Harvard School of Public Health

---

<div class="post-metadata">

**Author:** ![gbbio](https://sea2.discourse-cdn.com/flex020/user_avatar/help.galaxyproject.org/gbbio/32/366_2.png) [@gbbio](https://help.galaxyproject.org/u/gbbio)\
**Post date:** [April 15, 2022, 8:25am UTC](https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806/3 "2022-04-15T08:25:35Z")

</div>

I don’t really know the answer but I see you really need one. I think I would try to make a back-up of the current database and set-up a new version 16 galaxy somewhere with that database so the current one can stay online. From this “new” version 16 galaxy you can try to upgrade to version 20. One of the key steps will be `sh manage_db.sh upgrade`. When you have version 20 working you could set-up a completely new and fresh version 20 and import the user tabel into that new fresh database. But again this is just a guess.

This may help [Galaxy Community Hub - Galaxy Community Hub](https://galaxyproject.org/admin/maintenance/)

You can also try to download version 20, point to the back-up database and try to run it. You will get a database version error and the error will tell you that you need to run `sh manage_db.sh upgrade`. But this faster way maybe also works.

Before you try to extract the user table and import it in a new database take a look at this as well, there are all kind of cleaning scripts available. :[Server Maintenance and Backups](https://training.galaxyproject.org/training-material/topics/admin/tutorials/maintenance/slides-plain.html)

One of the main reasons my “guess” to do all these steps is because of the big step (from 16 to 20).

Import things to keep in mind and save you some troubles are the postgresql and python version.

Another way to get support is to use the chat (right bottom corner) of the main page [https://galaxyproject.org/](https://galaxyproject.org/).

---

<div class="post-metadata">

**Author:** ![george.weingart](https://sea2.discourse-cdn.com/flex020/user_avatar/help.galaxyproject.org/george.weingart/32/1770_2.png) [@george.weingart](https://help.galaxyproject.org/u/george.weingart)\
**Post date:** [April 15, 2022, 6:11pm UTC](https://help.galaxyproject.org/t/how-to-migrate-only-the-users-from-rel-16-to-release-20/7806/4 "2022-04-15T18:11:29Z")

</div>

Hi gbbio,  
Thank you so much for your reply.  
Unfortunately, it is not exactly what we need.  
We upgraded to 20 in a Docker environment with the vanilla database.  
We need a script to copy all the User tables from our Production Rel 16 to the new Release 20.  
It is a huge Production environment and we need a definite answer from Galaxy Support.  
But, Thanks so much for your your response !  
George Weingart PhD  
Huttenhower Lab  
Harvard School of Public Health
