Hi,
Is it possible for the commerce site running on one server to point
to another database. I tried changing the connection string of the
Profiles global resource but I get an exception when I try to run the
application. Please assist.

Thanks in advance

[ Post a follow-up to this message ]

What kind of error are you getting? Make sure you change the Partitions
as well. There are several connection strings associated with profiles.
This should work with no problem. Let me know.

ukeu wrote:
> Hi,
>     Is it possible for the commerce site running on one server to point
> to another database. I tried changing the connection string of the
> Profiles global resource but I get an exception when I try to run the
> application. Please assist.
>
> Thanks in advance

[ Post a follow-up to this message ]

Can you please let me know what are the steps I need to follow for
this. I changed the connection string in the 'Global Resources' section
in Commerce server manager. Further, do you how we need to point to
campaigns? I took an entire backup of my site's sitename_commerce
database and restored it on another server. I also deployed my code
there. However, when I run the application from that(staging) server, I
get an 'Unspecified Error' exception. Can you please give me some steps
to follow. I'm totally new to Commerce server. Please assist.

Thanks very much
gottlieblists@gmail.com wrote:
[vbcol=seagreen]
> What kind of error are you getting? Make sure you change the Partitions
> as well. There are several connection strings associated with profiles.
> This should work with no problem. Let me know.
>
> ukeu wrote: 

[ Post a follow-up to this message ]

Each resource in a Commerce Site has a set of connection strings associated
with it.  You will need to manually change each one if you are manually
moving your database.  A much easier way to move your databases would be to
pack your site into a pup package, then use the custom un-pup process to
unpack to different databases.

But even with a pack/unpack, you still need to change you profile data
source connection strings manually.  To do this, in Commerce Server Manager
browse to Global Resources --> Profiles --> Profile Catalog --> Data
Sources --> ProfileService_SQLSource --> Partitions.  In the right pane,
edit the connection string of each partition listed.

- David

--------------------
From: "ukeu" <sairaj282@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Pointing to a new Profile Database
Date: 22 Jul 2006 02:55:25 -0700
Organization: http://groups.google.com
Lines: 25
Message-ID: <1153562125.207778.317250@p79g2000cwp.googlegroups.com>
References: <1153395201.859413.135140@m73g2000cwd.googlegroups.com>
<1153495442.034850.79550@h48g2000cwc.googlegroups.com>
NNTP-Posting-Host: 161.12.7.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1153562130 3049 127.0.0.1 (22 Jul 2006 09:55:30
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 22 Jul 2006 09:55:30 +0000 (UTC)
In-Reply-To: <1153495442.034850.79550@h48g2000cwc.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1;
NET CLR 1.1.4322; .NET CLR 1.0.3705),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 PORWI004, 1.0 HAVWI004
Complaints-To: groups-abuse@google.com
Injection-Info: p79g2000cwp.googlegroups.com; posting-host=161.12.7.4;
posting-account=N2WhYA0AAABwhAt4rOVj9xVHfCvoiV--
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!news.glorb.com!postnews.google.com!p79g2000cw
p.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18050
X-Tomcat-NG: microsoft.public.commerceserver.general

Can you please let me know what are the steps I need to follow for
this. I changed the connection string in the 'Global Resources' section
in Commerce server manager. Further, do you how we need to point to
campaigns? I took an entire backup of my site's sitename_commerce
database and restored it on another server. I also deployed my code
there. However, when I run the application from that(staging) server, I
get an 'Unspecified Error' exception. Can you please give me some steps
to follow. I'm totally new to Commerce server. Please assist.

Thanks very much
gottlieblists@gmail.com wrote:
[vbcol=seagreen]
> What kind of error are you getting? Make sure you change the Partitions
> as well. There are several connection strings associated with profiles.
> This should work with no problem. Let me know.
>
> ukeu wrote: 




--

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.

Attachment:
This has been downloaded 0 time(s).

[ Post a follow-up to this message ]