Grouper Developers Forum

[Chris Hyzer <>]

> MSSQLServer supports views.

 

Yes, we were curious if its ddl was similar to what we were using for the other dbs… I had already confirmed that it appeared similar, we just need to test everything, but it looks like there are no issues there

 

Thanks,

Chris

 

From: David Langenberg [mailto:]
Sent: Tuesday, June 16, 2009 5:25 PM
To: 'Grouper Dev'
Subject: RE: [grouper-dev] Minutes: Grouper Call 10-June-09

 

 

 

From: Emily Eisbruch [mailto:]
Sent: Tuesday, June 16, 2009 5:19 PM
To: Grouper Dev
Subject: [grouper-dev] Minutes: Grouper Call 10-June-09

 

**Grouper Call 10-June-09**

 

 *Attending*

 

Tom Barton, U. Chicago (chair)

RL “Bob” Morgan, University of Washington

Gary Brown, Bristol 

James Cramton, Brown

Shilen Patel, Duke 

Chris Hyzer, U. Penn 

Tom Zeller, U. Memphis 

Steve Olshansky, Internet2   

Ann West, EDUCAUSE/Internet2 

Emily Eisbruch, Internet2 (scribe) 

 

<<SNIP>>

 

 

**Database Views**

 

https://bugs.internet2.edu/jira/browse/GRP-288

 

This is a proposal to assume the Grouper registry runs in a database that supports views. This will permit re-use of SQL logic and allow for simpler queries. A consequence of this change is that Grouper would not work on a database that does not support views.

 

Right now the MySQL, Postgress,  Oracle, and HSQL all support views.

 

Question about MSSQL:  Does it support views? 

U. Chicago is using Grouper with MSSQL. Chris added MSSQL to the list of supported databases in the release steps:

https://wiki.internet2.edu/confluence/display/GrouperWG/Release+steps

 

Decision: Move in the direction of relying on database views in Grouper IF this is supported by MSSQL. 

 

MSSQLServer supports views.

 

Dave

 

================================

David Langenberg

Network Based Services

The University of Chicago

================================