You’re offline. This is a read only version of the page.
We refresh our Dynamics GP databases in a Test environment from the Production databases once per week.
We currently use the Software Debugging Tool (SDT) to manually set the same background color of all 30 Test companies after every weekly refresh.
Its pretty straightforward to append <TEST> to all the company names using T-SQL after a weekly refresh but setting the background color is not so straightforward. Our use of the SDT has only been in recent times so our knowledge is limited. Is there any 'automated' way to get the same background color set for the 30 refreshed databases each week ?
*This post is locked for comments
Glad we could get that sorted for you. Once they upgrade to a supported version you will be able to install GP Power Tools instead and get all the extra functionality.
Thanks David for the additional pointers .. all sorted now with GP 10.
Please make sure you are running the final build 19 of the SDT, the v10 install file can be downloaded from
http://www.winthropdc.com/products_SDT.htm
Here is how to see the records.
select * from DYNAMICS.dbo.SY01402 where USERID like ' DEBUGGER,%' and (syDefaultType >= 22003 and syDefaultType <= 22005)
select * from TWO.dbo.SY01401 where USERID like ' DEBUGGER%' and (coDefaultType >= 22001 and coDefaultType <= 22003)
Note the USERID has space as the first character. In the system database, the Company ID is appended to the USERID.
You should be able to update the system database only and the companies should inherit the change when they first are logged into.
David
Thanks for the reply David. Yes, different servers .. prod is in Sydney and test is in Melbourne. Finance Dept here is upgrading to GP 2015 later this year but currently on GP 10 so GPPT not an option. Dynamics GP consultants (unnamed) gave us the refresh SQL script but sounds like once the colours are set up the test DYNAMICS database shouldn't be overwritten. Having colours to denote TEST is nice but can be dispensed with until the GP 2015 upgrade .. will purchase GPPT then.
Thanks Mahmoud for notifying me of this thread.
Please note that the Support Debugging Tool (SDT) was discontinued when I left Microsoft in October 2014.
It has been replaced by GP Power Tools (GPPT) which offers all the features of the SDT plus many fixes and new features. GPPT also moves all the data storage to SQL and no longer uses the Debugger.xml file (except for setting backup and restore).
Please see http://WinthropDC.com/GPPT for more information.
The situation where you copy a live company to a test company on the same server should not have a problem as the company colours are stored in both the system and company databases and so when you copy Live to Test, the colour for that company will be taken from the system database and update the company database. This means that creating test companies will keep their "test" colours.
Your situation sounds like you are copying all databases from one server to another, including the system database. Then marking all databases on the test server as test. The build in handling will not help you with this.
Once you have upgraded to GPPT, I would be able to tell you to what tables are used to store the colour schemes for each company.
David
David Musgrave must have a considerable insight on your question
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (