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: "Hyzer, Chris" <>
  • To: Shaun Koh <>, " Mailing List" <>
  • Subject: [grouper-users] Re: DB SQL Query
  • Date: Thu, 22 Mar 2018 11:57:04 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:n/qBGRY/sR16oRhzswmIIe7/LSx+4OfEezUN459isYplN5qZpsy4Yh7h7PlgxGXEQZ/co6odzbaO6Oa4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahb75+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTyxPDJ2hYYsTAeQPPuhYoIv8p1QSohSzHhOjCP/zxjJSmnP6wa033uI8Gg/GxgwgGNcOvWzaoNv3NKYTUP66zLPQwT7ecf5W2S396InTchwvvPqBWrdwftbRyUgvFgLKkE+QpJfkPzOOyusBqXWb7/J+WuKpjW4rsR9+rSWyxso1jITCm4Ebykjc+Cln2ok5OcC0RUtmbdK5DZddsi+aOoRqTs8+Rmxlujg1x7IatZO+eSUG1ogrywPHZ/Cab4SE/gjvWPuMLTtihH9oeqizihev/US4xO3zSMq53EpPoydAndTBtnEA2AfW58WDVPdx4EWs1DOA2gzO8O5JLkU5mrHVJpI9xrM9kIcYv17ZES/sgkr2ibebdkU69eis7OTqeq3oq4ObOYNolw3yK7kglNSiDeghNQgBRHaU9f671L3+4U32W7JKjuAwkqbEqpzaPd4bpqmlAwBLzokj9xe/DzCg0NgCmnkHMU5FeBaAj4juOFHCOuz3DfC6g1i0kTdrwe7JPqH5D5nTNHfPjKrtcLNg50JB1QY+yN5f6p1IBr0dJf/+WFH+udPEAhI8NgG43frrBMhl2oMbQ22PA6uZMK3IsV+P4+IiO+yMa5MVuDf9Kvkq+eTugGQ4mV8GYaalx4YXaGimEfRgJUWVe2TjjcocEWsSpAoxUPTqiEGeUT5Uf3uyULg85jYmCIK+E4jDXJmhgKGa3CilBJ1WfXtLClSNEXfza4WEQOkAZDiTIs9njjwLS6KhS4k/2hGyqgP20aRoIffJ+n5QiZW279h8+uubthYyvWhvD82A1SeOSGFcl34DRDs/2qw5qEc7zEXVleAyjOZfCMRe/bZUSQogLrbdyfB3Edb/RliHc9uUAHOvQ9GnBz55atMq35VGN0lnHMi6gwqGwjGnGaQ9lrqXCYYy/76GmXX9OpAu5WzB0fxrr0g0T9ELfUamnK9kvUCHAoXJgleUjY6rbq9awTbA8mHFwGaT6hILGDVsWLnICChMLnDdqs70swabF+ej
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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