Grouper database migration utility example from mysql to postgres

Start with an empty postgres database (destination)

1. Point grouper and clear out postgres: grouper.hibernate.properties
   
   

   hibernate.connection.url = jdbc:postgresql://localhost:5432/postgres?currentSchema=grouper_v2_5 hibernate.connection.username = grouper_v2_5 # If you are using an empty password, depending upon your version of # Java and Ant you may need to specify a password of "". # Note: you can keep passwords external and encrypted: https://bugs.internet2.edu/jira/browse/GRP-122 hibernate.connection.password = *********

   
   
   

2. Run gsh command to clear out database

   ./gsh.sh -registry -droponly -runscript 2021-08-30 09:55:35,203: [main] WARN GrouperAntProject.log(96) - - SQL: DROP VIEW IF EXISTS grouper_ext_subj_v cascade 2021-08-30 09:55:35,224: [main] WARN GrouperAntProject.log(96) - - 0 rows affected 2021-08-30 09:55:35,317: [main] WARN GrouperAntProject.log(96) - - SQL: ALTER TABLE grouper_group_set DROP constraint fk_group_set_member_field_id 2021-08-30 09:55:35,317: [main] WARN GrouperAntProject.log(96) - - 0 rows affected ...

   
   
   

3. See the empty database
   

   
   
   

Point grouper at mysql, and see folders and groups

1. grouper.hibernate.properties
   
   

   hibernate.connection.url = jdbc:mysql://localhost:3306/grouper_v2_5?useSSL=false hibernate.connection.username = grouper_v2_5 # If you are using an empty password, depending upon your version of # Java and Ant you may need to specify a password of "". # Note: you can keep passwords external and encrypted: https://bugs.internet2.edu/jira/browse/GRP-122 hibernate.connection.password = ******* hibernate.jdbc.batch_size = 1000

   
   
   

2. See some groups
   

   
   
   

Add a database connection for postgres in external system

Test connection

Make a file migrateToPostgres.gsh

Invoke that script