Retail Configuration | Copy from Source to Destination environment in AX 2012 R3

Hi Guys,

In this blog, we are going to see, how can we copy different setups from one environment to another, without any development. You might have come across the different tool to transfer the data from Test to PROD environment, but here we will have a look at the most simple tool i.e “Definition group”.

With “Definition groups”, you can export a single table or group of tables (for a particular set of configuration), that can be directly imported in the destination environment. The “Definition groups” when exported create DAT and DEF file which is required at the time of import. However during import you only select the DAT file.

Export single table in a definition group

Here we will take example of Retail Language Text. This table is legal entity specific and sometimes , if you are dealing with multiple legal entity using same language, you wont be creating the same language text manually again Or if you want to migrate this data to another environment. This can be very time consuming.

Follow below steps:

In your source environment, navigate to System administration >> Common >> Data export/import >> Definition groups.

Click New.

In General tab, enter Definition group as “LanText” and Description as “Language Text”.

In Options tab, un-check everything.

In Include table groups, un-check everything.

Click OK.

Click Select tables.

Add RetailLanguageText table and click Close.

Click “Export to”

Enter the File name and click OK.

This will create 2 files .dat and .def. Copy these files to destination environment.

In destination environment, navigate to System administration >> Common >> Data export/import >> import.

In File name, select the .dat file and click OK.

You can perform the above steps for Receipt formats as well (RetailFormLayout).

Export multiple tables in a definition group

Here we will take example of Screen layouts. Screen layout comprises of multiple tables and unless you import all data, the screen layout is not complete.

Follow below steps:

In your source environment, navigate to System administration >> Common >> Data export/import >> Definition groups.

Click New.

In General tab, enter Definition group and Description.

In Options tab, un-check everything.

In Include table groups, un-check everything.

Click OK.

Click Select tables.

Add tables shown in above screenhot and click Close.

Click “Export to”

Enter the File name and click OK.

This will create 2 files .dat and .def. Copy these files to destination environment.

In destination environment, navigate to System administration >> Common >> Data export/import >> import.

In File name, select the .dat file and click OK.

Check the screen layouts.

Feel free to reach out for any clarifications. If you like my blog posts then comment and subscribe to the blogs.

You can connect with me on- Facebook | Google+ | Twitter | Skype (sumit0417)

Enjoy RetailDAXing.

Disclaimer: The information in the weblog is provided “AS IS”; with no warranties, and confers no rights. All blog entries and editorial comments are the opinions of the author.