The Support Debugging Tool has a fantastic XML Table Export and Import features. This can be used to achieve fantastic things like –
- David Musgrave showed – how to transfer Security Tasks and Roles between Systems. This is useful when you are migrating security from Test to Production.
- Mariano Gomez used the XML Table import as one of the ways of Transferring Extender customizations from one company database to another
Another use that we recently tested this feature was in migrating the Analytical Accounting Dimensions and Codes from Test to Production. Often people test out the AA Codes and Dimensions in a test environment, and when they are happy with what they want they want to set it up in Production. SDT allows you to transfer this in a snap, instead of manually setting things up again in Production.
As a bonus, the article also covers the ability of running SQL scripts from inside GP using the SQL Execute option of Support Debugging Tool.
Read the complete article here - Dynamics GP SDT Essential Series 2 – Transfer AA Dimensions and Codes from Test to Production