[译]Dynamics AX数据维护和迁移技巧

原文地址：https://www.codeproject.com/Articles/411814/Dynamics-AX-Data-Maintenance-Migration-Tips

原文作者：Venkat Chaitanya Kanumukula

译文由本站 robot-v1.0 翻译

前言

Maintenance of Definition’s in multiple Dynamics AX Environments 在多个Dynamics AX环境中维护定义

介绍(Introduction)

本文主要针对中级(This article is intended primarily for intermediate)Microsoft Dynamics AX(Microsoft Dynamics AX)熟悉的用户(users who are familiar with)AX用户界面(AX User Interface).本文的目的是通过提供在不同组之间维护/移动"定义组"的提示来帮助用户.(. The Goal of this article is to help the users by providing the tips on maintaining/moving “Definition Groups” between different)动态AX(Dynamics AX)环境.本文的重点不是数据,而是建议/教导在不同领域保持相同的"定义"(environments. The focus of this article is not the data, but to advise/teach on maintaining the same “Definitions” across different)斧头(AX)环境.(environments.) 基本上(Basically the)DAT/DEF(DAT/DEF)用于导出/导入之间的数据(is used to Export/Import data between)AX AOS服务器(AX AOS Servers).通常,Microsoft Dynamics AX数据导入/导出用于将数据从登台环境移动到另一个环境.定义组标识使用Microsoft Dynamics AX时可以导入或导出的表组(. In general, Microsoft Dynamics AX data import/export is used to move data from a staging environment to another environment. Definition groups identify groups of tables that can be imported or exported when you use Microsoft Dynamics AX)数据导入/导出(data import/export)下(under)系统管理(System Administration).定义组必须在导出数据之前设置,但在导入数据时不是必需的.(. Definition groups must be set up before you export data, but are not required when you import data.) 据了解,已找到此类文章,该文章解释/着重于如何导出定义文件以及预定义的表和条件列表,(To the best of knowledge know such article was found which explains/focuses on how to export the Definition file along with the predefined list of tables and criteria, a)建立(Setup)已创建并希望将其带到其他环境而不重新创建.(that was created and want to carry it to other Environments without recreating it.) 注意(Note):表列表和"(: List of tables and “)标准(Criteria)的"和”(’s" and “)范围(Ranges)在定义组下的每个表上选择的"存储在(” selected on each table under a definition group are stored in the)SYSEXPIMPTABLEQUERY(SYSEXPIMPTABLEQUERY)表.(table.)

SELECT GROUPID, QUERYRANGE, QUERYPACKED FROM SYSEXPIMPTABLEQUERY

请按照此处的步骤操作.(Follow the steps here.) 登录到AX:用户应该具有AX"系统管理员"角色才能导航到以下屏幕.(LogIn into AX : The user should have AX “System Adminstrator” Role to navaigate to the below screen.) 导航(Navigate to)系统管理(System administration)|普通数据导出/导入(| Common | Data export/import)

注意:在下面的示范中(Note : Here in the below demonstration)反式(Trans)和(and)Ex_def(Ex_def)用作样本名称,可以用用户选择的任何名称替换.在以下示例中,使用Ex_def组导出了Trans Definition.通过使用另一个定义组,可以导出定义组.(are used as sample names, this could be replaced with any name of users choice. In the below example Trans Definition is exported using Ex_def group. Exporting the definition groups is possible by using another Definition group.) 假设您已经在名为"“的组中定义了一些表(Lets assume that you have some tables already defined in the group named “)反式(Trans)“作为下图所示的示例,并希望将该定义文件导出到另一个AX环境.(” as an example shown in the below Image and wanted to export that definition file to another AX environment.)

要使用相同的表和条件集导出上述定义文件,您需要创建另一个定义文件,该文件可以为我们导出它.因此,将新的定义组创建为”(To export the above definition file with the same set of Tables and criteria’s, you need to create another definition file which can do the trick to export it for us. So create a new definition group as “)Ex_def(Ex_def)",然后将说明另存为”(” and save the description as “)导出定义(Export Definitions)",以便清楚地了解其目的.(” so that it is clear in understanding the purpose of it.)

看到"(See that all the check boxes under “)选件(Options)“标签和”(” tab and “)包括表组(Include table groups)“标签处于未选中状态.这样您就不会将任何表加载到此新定义中.用户应该看到一条新记录,如下图所示.单击”(” tab are unchecked. This way you are not loading any tables into this new definition. The user should see a new record like the one shown in the below image. Click “)选择表格(Select tables)菜单栏中的"".(” from menu bar.)

选择表格(Select tables)

在"(In “)选择表格(Select tables)表格只需在"表格名称"列中输入"(” Form just type the “Name of the table” Column as “)SysExpImpGroup(SysExpImpGroup)" 在里面.然后选中或选中"(” in it. And check or select the box “)应用条件(Apply criteria)“列,然后点击”(” column and click the “)出口标准(Export criteria)" 来自(” from the)菜单栏(Menu bar)在表格的顶部.(on the top of the form.) 点击"(Clicking on “)出口标准(Export criteria)“应带您到以下屏幕.(” should take you to the below screen.)

该表格有助于在以下位置创建查询(This Form helps in creating a query on)SysExpImpGroup表(定义导入/导出组)(SysExpImpGroup table(Define import/export groups)).从"下拉菜单"的下拉菜单中选择定义的名称(例如:” Trans")(. Select the name of the definition (ex : “Trans”) from the dropdown in the “)标准(Criteria)旨在移至另一个AX环境中的列,然后单击表单底部的"确定"按钮.(” column which was intended to move into another AX environment and click OK button at the bottom of the form.) 这应该带您回到"(This should take you back to “)选择表格(Select tables)“表单.然后选中”(” Form. Then select the checkbox under “)指定相关表(Specify related tables)",如下图所示,然后点击"(” as shown in the below screen and click on the “)选择相关表(Select related tables)“位于"表单"菜单栏顶部.(” on the top of the Form menu bar.)

点击”(Clicking the “)选择相关表(Select related tables)“将为您提供以下表格和表格列表.(” will present you with the following form with a list of tables.)

不要修改此表单中的任何内容,保持原样并关闭它.您应该在”(Do not modify anything in this form, leave that as it is and close it. You should see the entire above displayed tables back in the “)选择表格(Select tables)“形式如下图所示.(” Form as shown in the below image.)

系统管理|普通数据导出/导入|输出到(System administration | Common | Data export/import | Export to) 这将带您进入”(This will take you to the “)导出选项(Export Options)表格如下图所示.(” Form as shown in the below Image.)

在"(In “)导出选项(Export Options)表格中,选择(” form, Select the)前_Def(Ex_Def)从"定义组"下拉列表中选择(from the “Definition group“ dropdown and select the)二元(Binary)来自 “(from the “)文件类型(File type)“下拉菜单,并将输出文件的名称传递为(” dropdown and pass the name of the output File as)转换数据(Trans.dat).选中后,此导出文件包含所有表格和条件的＆范围信息(. This exported file contains all the tables and criteria’s & ranges information when selected)二元(Binary)格式化为"文件类型"输出,而不是(Format as “File Type” output instead of)逗号(Comma).汇入这个(. Import this)DAT(DAT)和(and)防御(DEF)文件放入新的AX环境.您应该看到具有相同名称的定义组(files into new AX Environment. You should see the definition group with the same name)反式(Trans)在新的(in the new)AX环境(AX environment)也一样它将完整保留所有表格名称,范围和条件.这避免了用户再次从头开始重新创建/重做它们,并为开发人员节省了大量时间.(as well. It will have all the Table names, Ranges and criteria’s intact. This avoids the user to recreate/redo them from scratch again and saves a lot of time to the developers.) 注意:如果文件导出到(Note: If the file is exported in)逗号(Comma)格式,那么您将只能获取表格信息,而不能获取范围和条件的信息.希望微软在不久的将来解决此问题.(format then you will only be able to get the Tables information, but not the ranges and Criteria’s. Hope Microsoft fixes this in the near future.) 导入DAT/DEF(Importing the DAT/DEF)也可以通过命令行使用XML文件作为AX32.exe的输入来完成文件.(files could also be done through command line using an XML file as Input to AX32.exe.) XML文件应该是这样的.(XML file should be some thing like this.) 注意:XML文件中参数值中的空格.(Note : Aviod spaces in the Parameter values in XML file.) 在"命令提示符"窗口中运行以下命令行.(Run the below command line in Command Prompt window.)

参考文献(References)

以下链接对AX开发人员也可能有用(The below link might also be useful to the AX developers) http://blogs.bojensen.eu/?p=527(http://blogs.bojensen.eu/?p=527)

结论(Conclusion)

上面提到的步骤演示确定导出包含表列表以及条件和范围的定义组也可以轻松迁移到不同的AX环境.(The above mentioned demonstration of steps determine that exporting the Definition groups which holds the List of tables along with criteria’s and ranges could also be migrated to different AX environments easily.) 我会把这篇文章献给我所有的人(I would dedicate this article to all my)好心人,朋友和同事(well-wishers, friends and colleagues).我特别感谢Richard Ward,John Reed和Todd Oberman.(. My special thanks to Richard Ward, John Reed and Todd Oberman.) 希望本文能达到目的.任何建议或更正是最欢迎的.(Hope this article will serve the purpose. Any suggestions or corrections are most welcome.)

许可

本文以及所有相关的源代码和文件均已获得The Code Project Open License (CPOL)的许可。