Subject: Grouper Users - Open Discussion List
- From: "Hyzer, Chris" <>
- To: Shaun Koh <>, " Mailing List" <>
- Subject: [grouper-users] RE: DB SQL Query
- Date: Mon, 26 Mar 2018 13:39:04 +0000
- Accept-language: en-US
- Authentication-results: spf=none (sender IP is ) ;
- Spamdiagnosticmetadata: NSPM
- Spamdiagnosticoutput: 1:99
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.
My apologies, yes in terms of the data entities/objects we are looking to sync just groups, stems, and memberships between the two systems.
From: Hyzer, Chris <>
you say groups, stems, memberships, etc. what is the "etc", or is it just groups, stems, memberships?
<> on behalf of Shaun Koh <>
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.
- [grouper-users] DB SQL Query, Shaun Koh, 03/22/2018
Archive powered by MHonArc 2.6.19.