Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Run a copy of the same database with a new DB name in Solomon 5.5

150 views
Skip to first unread message

Nigel Glasgow

unread,
Dec 12, 2005, 10:16:46 PM12/12/05
to
Hi all,

Does anyone know how to run a copy of the same DB on the same server
with a different name.
Please hellp since we want to test some outputs and customisations with our
current data from our live DB.

Thanks.
Nigbev.

Sos

unread,
Dec 12, 2005, 11:39:03 PM12/12/05
to
Create a new system and app database. Restore this databases from the back up
of your live database.

Run the following script.

USE
SIVDevSystem -- The new restored database.

UPDATE
Company
SET
DatabaseName = 'SIVDevApp', -- Point to restored application database name.
CpnyName = 'Test Company' -- Company name - displays in file menu and on
reports.
WHERE
CpnyID = '0100'

SELECT -- Check update.
CpnyID,
DataBaseName,
CpnyName
FROM
Company


UPDATE
Domain
SET
-- ServerName = ServerName, -- Only if restored to different sever.
DatabaseName = 'SIVDevApp' -- Point to restored application database name.
WHERE
DatabaseName = 'SIVHTGApp'

SELECT -- Check update.
DatabaseName,
ServerName
FROM
Domain
WHERE
DatabaseName = 'SIVDevApp'


Once that's done you log into Solomon using the test database and do your
necessary tests without fearing corrupting live data.

Cheers,
Sos

Rohtash Kapoor

unread,
Dec 13, 2005, 12:39:56 AM12/13/05
to
.........and the last step is to UPDATE VIEWS in Database Maintenance.

---
Rohtash Kapoor
http://www.microsoftdynamicsforums.com

"Sos" <S...@discussions.microsoft.com> wrote in message
news:386D4E23-2E46-4946...@microsoft.com...

NAG

unread,
Dec 13, 2005, 12:17:59 AM12/13/05
to
Thanks a million for guidance.
Will update you on progress in 24 hrs
NAG>

"Rohtash Kapoor" <rohtash...@microsoftdynamicsforums.com> wrote in
message news:%23%23kdne6$FHA...@tk2msftngp13.phx.gbl...

Amy Junkins [MSFT]

unread,
Dec 13, 2005, 9:51:32 AM12/13/05
to
Nigel,
The instructions are similar to what is published in the following
Knowledge Base article:

847681- Restore Solomon databases for testing or archive purposes
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;847681


Kind Regards,
Amy Junkins
Microsoft Online Support

Certified Master – Solomon Applications
Certified Professional – Solomon Installation and Configuration

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

0 new messages