Discussion:
SQL Definitions for Schema roles
(too old to reply)
Colin Bowern
2006-11-05 06:20:38 UTC
Permalink
I can't seem to locate the SQL definition files for the following roles in
the CS2007 SDK or other SQL source files:

* Profile_Schema_Manager
* Profile_Schema_Reader

Did I totally miss them because they aren't in ProfileSQL.sql, yet magically
they come out of the Starter Site and CSharpSite Package?

Thanks,
Colin
Colin Bowern
2006-11-05 06:34:07 UTC
Permalink
And I found it tucked away in a not so obvious place:

C:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce
Server\CatalogSchema.sql

It looks like whoever was doing the packaging should really consider
packaging all SQL files together in the SiteCreate folder.

Cheers,
Colin
Post by Colin Bowern
I can't seem to locate the SQL definition files for the following roles in
* Profile_Schema_Manager
* Profile_Schema_Reader
Did I totally miss them because they aren't in ProfileSQL.sql, yet
magically they come out of the Starter Site and CSharpSite Package?
Thanks,
Colin
David Hargis [MSFT]
2006-11-06 17:50:55 UTC
Permalink
The role is automatically created on the <sitename>_profiles database when
you unpack CSharp.pup or Starter.pup.

- David

--------------------
From: "Colin Bowern" <***@hotmail.com>
References: <28E1698D-69E4-4030-9AE7-***@microsoft.com>
Subject: Re: SQL Definitions for Schema roles
Date: Sun, 5 Nov 2006 01:34:07 -0500
Keywords: < Not Specified >
Lines: 25
Message-ID: <5CF0F044-A68B-46F5-8238-***@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Live Mail desktop 8.0.1083
X-MimeOLE: Produced By Microsoft MimeOLE V8.0.1083
X-MS-CommunityGroup-PostID: {5CF0F044-A68B-46F5-8238-278490D29ACE}
X-MS-CommunityGroup-ThreadID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
X-MS-CommunityGroup-ParentID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
Newsgroups: microsoft.public.commerceserver.userprofilemgt
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.userprofilemgt:3686
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 127.0.0.1
X-Tomcat-NG: microsoft.public.commerceserver.userprofilemgt

And I found it tucked away in a not so obvious place:

C:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce
Server\CatalogSchema.sql

It looks like whoever was doing the packaging should really consider
packaging all SQL files together in the SiteCreate folder.

Cheers,
Colin
Post by Colin Bowern
I can't seem to locate the SQL definition files for the following roles in
* Profile_Schema_Manager
* Profile_Schema_Reader
Did I totally miss them because they aren't in ProfileSQL.sql, yet
magically they come out of the Starter Site and CSharpSite Package?
Thanks,
Colin
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
Colin Bowern
2006-11-06 18:04:43 UTC
Permalink
Hi David,

We're not using the Site Packager because there isn't an abundance of
documentation and examples to speak to automating and packaging
customizations. My past experience has also seen it fail at critical times
with cryptic error messages. Given the existence of the SiteCreate example
from the CS2002 SDK and carried forward into CS2007 we have rolled our own
(http://blogs.rockstarguys.com/blogs/colin/archive/2006/11/05/14.aspx) for
now.

Cheers,
Colin
Post by David Hargis [MSFT]
The role is automatically created on the <sitename>_profiles database when
you unpack CSharp.pup or Starter.pup.
- David
--------------------
Subject: Re: SQL Definitions for Schema roles
Date: Sun, 5 Nov 2006 01:34:07 -0500
Keywords: < Not Specified >
Lines: 25
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Live Mail desktop 8.0.1083
X-MimeOLE: Produced By Microsoft MimeOLE V8.0.1083
X-MS-CommunityGroup-PostID: {5CF0F044-A68B-46F5-8238-278490D29ACE}
X-MS-CommunityGroup-ThreadID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
X-MS-CommunityGroup-ParentID: 28E1698D-69E4-4030-9AE7-AA57178CFAA8
Newsgroups: microsoft.public.commerceserver.userprofilemgt
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.userprofilemgt:3686
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 127.0.0.1
X-Tomcat-NG: microsoft.public.commerceserver.userprofilemgt
C:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce
Server\CatalogSchema.sql
It looks like whoever was doing the packaging should really consider
packaging all SQL files together in the SiteCreate folder.
Cheers,
Colin
Post by Colin Bowern
I can't seem to locate the SQL definition files for the following roles in
* Profile_Schema_Manager
* Profile_Schema_Reader
Did I totally miss them because they aren't in ProfileSQL.sql, yet
magically they come out of the Starter Site and CSharpSite Package?
Thanks,
Colin
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
Loading...