Creating a test database

(0) Share

Report

Posted on by megland

172

How do you create a test database? This way we can copy our main database to the test database in order to test transactions when we need to. We have Microsoft Dynamics SL 2011 FP1.

Thank you,

Marissa

*This post is locked for comments

All responses (3)

Answers (0)

Butch Adams 4,763 on at

Like (0)

Report

RE: Creating a test database

I haven't ever tried adding a test App DB to the same system database as its production counterpart. As I noted above, I also copy backup and restore the System DB as well. I also try to have it on a different server when I have the resources.

As for your description in the new thread you started, all I can think to suggest is that you make sure the new "company's" entries are correct in the Domain and the Company tables.
Rennecia Barran on at

Like (0)

Report

RE: Creating a test database

Hi Butch,

I did as you noted. I am able to log in to the company i can access master records, but I cannot see any transactions. Do you know what may be causing this?

Note i just created an additional database that uses the existing system database.
Suggested answer

Butch Adams 4,763 on at

Like (2)

Report

RE: Creating a test database

1. Restore a backup of the App and Sys databases.

2. Next you need to update the Domain and Company tables in the Sys database

Here is what I do:

update Domain set DatabaseName = 'TESTAPP' where DatabaseName = 'PRODAPP'

update Domain set DatabaseName = 'TESTSYS' where DatabaseName = 'PRODSYS'

update Domain set ServerName = 'TESTSERVER'

update Company set DatabaseName = 'TESTAPP' where DatabaseName = 'PRODAPP'

update Company set CpnyColor = 255

update Company set CpnyName = '-- TEST -- ' + LEFT(CpnyName,19)

3. Run Synchronize all Ownership and Security. Note that if you are restoring to the same server your production databases are on, you should get everyone out of SL. This synchronizes every database it finds on the server and can cause problems if people are processing in it.

4. Run Update Views

5. Login and enjoy.