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: Mon, 26 Mar 2018 13:39:04 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:TAj2FB1qeAhXOtyXsmDT+DRfVm0co7zxezQtwd8ZseMfKvad9pjvdHbS+e9qxAeQG9mDsLQc06L/iOPJYSQ4+5GPsXQPItRndiQuroEopTEmG9OPEkbhLfTnPGQQFcVGU0J5rTngaRAGUMnxaEfPrXKs8DUcBgvwNRZvJuTyB4Xek9m72/q99pHPbQhEniaxba9vJxiqsAvdsdUbj5F/Iagr0BvJpXVIe+VSxWx2IF+Yggjx6MSt8pN96ipco/0u+dJOXqX8ZKQ4UKdXDC86PGAv5c3krgfMQA2S7XYBSGoWkx5IAw/Y7BHmW5r6ryX3uvZh1CScIMb7Vq4/Vyi84Kh3SR/okCYHOCA/8GHLkcx7kaZXrAu8qxBj34LYZYeYP+d8cKzAZ9MXXWpPUNhMWSxdDI2ybIUPAOgAPelEoIbwvEEBoQeiCQS2GO/j1iFEi3nr1qM6yeQhFgTG0RQuE9wMsHXVrcv6NL0KXeuo0qTIzS/Db/JN2Tvz9YPFdRUhru2MXbNwcMve11MvGhjEjlWLtYPpJS6V1vwTvGid6epsT/yghHM6qwxopDWk28QiipHRi44L1lzJ9z91zYk0KNGiVUJ2YNCpHIFTuiyYL4d6X80vT31ytCs+17EKo4C3cDUOxZg92hLSaf2Kf5CG4h39V+udPTJ1iXdldb+7nRm9702tx+7gWcaq1FtHqzZKncTWuXwQ0hHe5cyKRuVy80qnxD2BzRrc6vteLkAxjafbK4Auwro3lpcLqUrOAij4lFnogKOPa0gq/Pak5/3gYrr9uJCQLYh0ihziMqs1ncy/HOI4PRUUU2iD4+S806Hj8lPlT7VWj/02la/ZvIrdJcQGuq65BwhV0oEg6xqlEzim19EYkWEGLFJDZh2Hk5DkN0/SLP36F/uyjFWhnC12y/3HMLDtGJbAI3rbnLfkZ7l96kpcyAQpzdBY4pJZErQBL+7zWk7xtd3XEAU5Phe1w+b8FNpxzJ4eWXqRDa+fNqPeq0GH6f8yI+WUfo8apC79K+Q55/7plXI5lkUdfa603ZsPdn+4BO1qI1iCYXXymNcBCnwHvg4/TOzxlF2CSiBfa2yzX6I6+jE0FpimDYHdSYCxnrCNxjm0EYBLZjMONlfZKnfhaoPMePAMIHaJIsZ8lHoHUriJQpIq1hWnsgO8wrEhKPiCvmVSuojkycB4/ajOjhwo7hR1CdiQyWeAUzsyk28VDxo/3aR+p0M17laYzeIw1/NCEsFL6ukMTxw3L4X0zupmBsr0Vx6bONqFVQD1bM+hBGR7bsMjzsVKK219AdS5xFiX2iGqEq0YjZSKH5dy77rR2X63KspgnSWVnJI9hkUrF5McfVatgbRyok2KX9bE
  • 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.

 

Thanks

Chris

 

From: Shaun Koh [mailto:]
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