|
Home > Archive > Commerce Server General > August 2006 > Sharing databases between sites in CS2007
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sharing databases between sites in CS2007
|
|
|
|
Is it possible/legal to have two sites to access the same global resource
database?
That is, if I create two sites, I get two global resources, for example for
the profiles with two different databases, right?
Now if I change the connection string to point to the first site's profiles
database they both point the same database even that they are different
global resources.
Is this doable (no conflicts or other) and legal, since what I've read, the
standard edition limits 1 site 1 global resource?
(hopefully I was clear. I'm a bit new on CS).
TIA!
ITP
| |
| David Hargis [MSFT] 2006-08-24, 7:20 pm |
| Absolutely!
You're just not quite going about it the right way. Rather than make two
Profiles resources have the same connection strings, you need to make the
sites share the exact same global Profiles resource. This is easily done
when you unPuP your site throgh the customn unpacking steps. When you get
to the 'Global Resource Pointers' page, just select the existing Profiles
resource from the drop down list so that the the table entry changes from
Profiles | (Add new global resource)
to
Profiles | Profiles(some_other_place)
If you already have your sites unpacked, you can open Commerce Server
Manager and browse to Commerce Sites --> Site2 --> Site Resources -->
Profiles(machine_Site2_profiles). Right click, select Properties. Just
change the value of s_RefResource to
"Profiles(machine_MyOtherSite_profiles)", or what ever the name of the
other global profile resource is. You can then safely delete the unused
Profiles resource and both sites will share the same profiles.
- David
--------------------
Thread-Topic: Sharing databases between sites in CS2007
thread-index: Acaqb6uEBCjbfcaxTrGwtNHiEQPCFA==
X-WBNR-Posting-Host: 213.215.236.130
From: =?Utf-8?B?SVRQ?= <ITP@discussions.microsoft.com>
Subject: Sharing databases between sites in CS2007
Date: Tue, 18 Jul 2006 06:40:02 -0700
Lines: 17
Message-ID: <028F59B2-0346-4653-8D7A-FD71F0D195AA@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18033
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Is it possible/legal to have two sites to access the same global resource
database?
That is, if I create two sites, I get two global resources, for example for
the profiles with two different databases, right?
Now if I change the connection string to point to the first site's profiles
database they both point the same database even that they are different
global resources.
Is this doable (no conflicts or other) and legal, since what I've read, the
standard edition limits 1 site 1 global resource?
(hopefully I was clear. I'm a bit new on CS).
TIA!
ITP
--
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.
|
|
|
|
|