|
Home > Archive > Commerce Server General > April 2006 > Copying Commerce Server databases
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 |
Copying Commerce Server databases
|
|
| daveym 2006-04-10, 7:35 pm |
| Hi all,
We recently went live, and we wish to set up a copy of the system. Whist
creating our model office, we had problems with SQL Server collation. This
resulted in some work being done to resolve this but unfortunately it failed.
What we have subsequently done is copy our databases from the live server to
the model office server. This appears to be okay apart from one thing. If we
change a profile detail on the MO, it changes on the Live!
I have done the following
1) Updated the commerce server manager connection strings to point to the
new model office.
2) Added host file values in the hope that if a live server is accessed, it
redirects to the model office.
What settings do I need to change to ensure that both systems are completely
isolated?
Thanks
Davey
| |
| David Hargis [MSFT] 2006-04-27, 7:27 am |
|
There is one more connection string that you need to update. This is the
profile system connection string that is used to connect to the DB that
contains profile data. It's stored in the 'ConnStr' column of the
'SourceDef' table.
Hope this helps,
David
--------------------
Thread-Topic: Copying Commerce Server databases
thread-index: AcZaSrnvQwZw7x9tTwW6v4bybg9ShA==
X-WBNR-Posting-Host: 194.176.201.15
From: =?Utf-8?B?ZGF2ZXlt?= <daveym@discussions.microsoft.com>
Subject: Copying Commerce Server databases
Date: Fri, 7 Apr 2006 06:54:02 -0700
Lines: 26
Message-ID: <04379CE7-5491-40A5-B404-6E092B63F2A2@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:17752
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi all,
We recently went live, and we wish to set up a copy of the system. Whist
creating our model office, we had problems with SQL Server collation. This
resulted in some work being done to resolve this but unfortunately it
failed.
What we have subsequently done is copy our databases from the live server
to
the model office server. This appears to be okay apart from one thing. If
we
change a profile detail on the MO, it changes on the Live!
I have done the following
1) Updated the commerce server manager connection strings to point to the
new model office.
2) Added host file values in the hope that if a live server is accessed, it
redirects to the model office.
What settings do I need to change to ensure that both systems are
completely
isolated?
Thanks
Davey
--
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.
|
|
|
|
|