Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: DB SQL Query

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: DB SQL Query

Chronological Thread 
  • From: Shaun Koh <>
  • To: "Hyzer, Chris" <>, " Mailing List" <>
  • Subject: [grouper-users] RE: DB SQL Query
  • Date: Mon, 26 Mar 2018 23:01:35 +0000
  • Accept-language: en-US, en-NZ
  • Ironport-phdr: 9a23:YxEW9BIlE5YHtGiyyNmcpTZWNBhigK39O0sv0rFitYgfK/3xwZ3uMQTl6Ol3ixeRBMOHs6kC07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffwtFiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QLYpUjqg8qhrUgflhicZOTAk7GHZhM9+jKxZrxKguxNwzJXZb5uJOPZiZK7RYc8WSXRHU81MVyJBGIS8b44XAuQcPeZXtZT9p10TphW7AgmsBP7kxzhThn/2x6I6zuIhHRvF3AwnH9IDq27brMjpO6cRVeC61q/IwijZY/xMxTjx8o7IcxE4rPyKQLl+ctLRxFEyGw7Lklmcs5LpMy6U2+gXrmSX8eptWfixh2Moqgx9uiWjy8kwhoXTmI4Z11HJ+T9kzIs1JtC0UkF2bcaqEJROtCyWK457T8YgTm10oyk3zrgLtJ20cSQUzJkqwhDSZOeJc4SU5x/sSuecITlki39jZbmxnQy98VK6xe35TsS00EhFri5CktTUs3AM2BPe5tGGSvt74ketwyyA1x3P5eFHJUA7j6zbJIM7zrEqipUfq0LDHy7ulEX3iq+ZaFkk9/C15+npfrnqvIGQO5J1hw3kL6gihMyyDf4mPgUBXmWX4eG826fi/U39TrVKlPo2kqzBvZDBJcQUvLO5AwlP3oYg7Ba/Dyyr384FnXYbL1JFfAiIj470NF3UOv/3Ee2zg1KtkTtz3fDJIqXhAonRLnjEiLrhcqx960lByAor099f/YtYCqwaIP3tQE/xr8fVDhs4Mwyv3+bnE8tx2pkfWWKJHq+WLrnSsVmW6eIzPeWAfpEatyvgK6tt2/m7x18oi1IHOeGC3YEWczrwSvFtI1SLbGDEg8wKV3oSsww4CuHmlQvGGXRcfXGvR68moywgBZi9JYbFWo23hrGdhmG2EoAeQ2lHDlGKHj/Mdp6YEb9YZziVP9dsiHkZTrW7UKcg0w2jrgn31+AhI+bJrH42r5XmgeN17vDV3TI19XQgFMSUzmfLTGZ0tmoVTDwy1aZz50V2jFGRh/sry8dEHMBesqsaGjwxMoTRmrR3

Hi Chris,


Thanks for your response.


I am not familiar with using the grouper loader though if I understand correctly from your suggestion and the docs, the sync can only be performed one-way from the existing app/system to Grouper. – or can the reverse also be done ?


The reason I ask is because (and apologies if I’ve not clarified) our cutover is phased such that both systems will actively be making changes at some point in time (due to business requirements and tightly coupled processes internal to the existing system) which requires a two-way sync for the data objects. – i.e. master-master relationship


This means after cutover, there would be no changes happening on the old system. Also, there are no privileges to migrate.


My thoughts are in line with yours in that editing the database registry directly should be avoided if possible due to the complexities involved so I am looking to spend some time evaluating if the loader could be of use to us in terms of applicability and performance.


Best Regards,

Shaun K.


From: Hyzer, Chris [mailto:]
Sent: Tuesday, 27 March 2018 2:39 a.m.
To: Shaun Koh; Mailing List
Subject: RE: DB SQL Query


Can you do a grouper loader job that does this pre-cutover (might take a while but that’s ok since cutover hasn’t happened), then do another run at cutover and it will be a lot faster.  This assumes the system of record is the old app before cutover.  After cutover I would assume you just need the diffs, or would changes still be happening on the old system?  Are there privileges to migrate too?


We would like to not have people edit the database registry directly since it is a little complicated and want to make sure people don’t corrupt things…  I assume you have analyzed the tables and will do so after (or during) the migration.





From: Shaun Koh []
Sent: Sunday, March 25, 2018 3:26 AM
To: Hyzer, Chris <>; Mailing List <>
Subject: Re: DB SQL Query


Hi Chris,


My apologies, yes in terms of the data entities/objects we are looking to sync just groups, stems, and memberships between the two systems.


Best Regards,

Shaun K.

From: Hyzer, Chris <>
Sent: Friday, March 23, 2018 12:57 AM
To: Shaun Koh; Mailing List
Subject: Re: DB SQL Query


you say groups, stems, memberships, etc.  what is the "etc", or is it just groups, stems, memberships?

From: <> on behalf of Shaun Koh <>
Sent: Thursday, March 22, 2018 1:18:09 AM
To: Mailing List
Subject: [grouper-users] DB SQL Query


Hi there,


We’re looking to perform a repeatable DB to DB sync to migrate a large dataset (and delta/changes thereafter) from our existing group management system to Grouper as we transition across.


An attempt via the web service resulted in slow performance due to the load size and tightly coupled internal processes within our existing system.


We are wondering if you could help point us to the source that includes the SQL logic for each type of group-related function/event (e.g. add/remove group, add/remove membership, stems, etc).


Please let me know if you would like some clarification on any of the above or if you have a recommended approach to performing this.


Best Regards,

Shaun K.

Archive powered by MHonArc 2.6.19.

Top of Page