web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Creating a test database
Microsoft Dynamics SL (Archived)

Creating a test database

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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.

  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    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.

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans