Hello. I have been using Metabase locally via the .jar and the H2 database on my personal computer. I have also set up a few coworkers with the same setup on their computers. Our initial intent was to explore the use of Metabase to query an Oracle database we have and we did not have access to a server for a proper setup.
Given the advice I found here on the Metabase Discourses, I have installed a local instance of a Postgres on each staff's computer and migrated the H2 data over to each Postgres. I have finally convinced my IT department to setup Metabase on an Openshift container platform with Postgres as the back end database.
So, all that said, I am in a situation where each staff has their own Dashboards/Queries/Reports on individual Postgres databases and I want to migrate them all over to my single Openshift Postgres. I have been searching for some methods and It's possible that I can use PG Admin to do this (among some other methods), but before I do this, I wanted to see if there will be any know issues by doing this. The one good thing I have in my favor, is that if/when I migrate all those Postgres databases Dashboards/Queries/Reports, they will be migrated to my account and not the individual accounts for each staff.
Any thoughts, suggestions or best practices would be appreciated.