Notifications
Announcements
No record found.
I'm not aware of any standard solution.
A traditional approach is (automatically) exporting some data from the target database before a DB restore and importing it back. I developed a framework for it in past (but I can't share it).
Another approach you might consider is not storing the configuration in database at all. You could use Azure App Configuration, for example, and have the configuration set up at a central place, with different values for different environments. There would be some design decisions to make (e.g. regarding a cache), therefore it's not just about calling the configuration service, but I think it might be useful. I haven't used it yet.
And I noticed one more approach in the recent solution for monitoring and telemetry. Microsoft there uses database for storing the values, but with environment ID as a key. An environment then looks for a record with its environment ID. It does the job, but it doesn't look ideal to me.
Some great ideas here Martin. The confirmation that there isn't anything "out of the box" is a big help. Azure App Configuration looks very cool. Does D365 have support for custom, memory resident environment variables that can be set at startup? Hope all is well.
A few options that come to my mind are SysGlobalObjectCache, SysGlobalCache and static class fields (e.g. in Singleton design pattern). The last two are per session; SysGlobalObjectCache should be shared across user sessions (on a given application server), but I don't know how it's actually implemented.
SysGlobalCache is basically a Map object held in system classes such as Info.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
