{"id":829,"date":"2013-09-09T17:56:25","date_gmt":"2013-09-09T16:56:25","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=829"},"modified":"2013-09-09T17:56:25","modified_gmt":"2013-09-09T16:56:25","slug":"exporting-common-ax-2009-environment-configuration-settings","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2013\/09\/exporting-common-ax-2009-environment-configuration-settings\/","title":{"rendered":"Exporting common AX 2009 Environment Configuration Settings"},"content":{"rendered":"<p>Wouldn&#8217;t it be great not having to re-configure certain configuration settings in your non-production environment after you&#8217;ve done an application\/data refresh?<\/p>\n<p>Well you can by exporting your common config settings using the Microsoft Database Publishing Wizard.<\/p>\n<p>What you end up with is a SQL script file to run against your AX database once you&#8217;ve completed your database restore, the only pre-requisites are you need the Database Publishing Wizard tool and also you need to export your settings before you overwrite your data (the last one is pretty obvious!!!).<br \/>\nSo the procedure would be as follows:<\/p>\n<ul>\n<li>\u00a0take a copy of the config settings in your non-production environment whose data is to be overwritten<\/li>\n<li>refresh your non-production environment with data from another environment<\/li>\n<li>execute the SQL script containing the config settings exported prior to the refresh into your non-production environment to replace them<\/li>\n<\/ul>\n<p>Download the guide here:<br \/>\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\" href=\"http:\/\/www.darrencoupland.com\/blog\/download\/961\/?tmstv=1776613179\" rel=\"nofollow\" id=\"download-link-961\" data-redirect=\"false\" >\n\tExporting-common-AX 2009-Environment-Configuration-Settings.pdf\t(7977 downloads\t)\n<\/a>\n<\/p>\n<p>You can add to the config\/tables being exported for any other config settings you require keeping in your environment.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Wouldn&#8217;t it be great not having to re-configure certain configuration settings in your non-production environment after you&#8217;ve done an application\/data refresh? Well you can by exporting your common config settings using the Microsoft Database Publishing Wizard. What you end up with is a SQL script file to run against your AX database once you&#8217;ve completed [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[29,57,8,59,27],"class_list":["post-829","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax-2009","tag-administration","tag-ax-environments","tag-ax2009","tag-dynamics-ax-2009","tag-nonproduction"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/829","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=829"}],"version-history":[{"count":4,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"predecessor-version":[{"id":914,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/829\/revisions\/914"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}