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

[Nigel Glasgow]

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]

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]

.........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]

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]]

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.