Posts

Showing posts from January, 2014

DIXF - Copy data between Ax systems

Image
At various points in time during an Ax implementation and following go live, it is necessary to move data between systems. Sometimes restoring the entire database is both unnecessary and inconvenient. Depending on who the tasks falls to (or who has time to complete it) there are a few different ways this can be achieved. A more technically inclined resource might look to the Test Data Transfer Tool. A more functionally minded resource might use the old definition groups, or the new (to Ax 2012 R2 CU7) Data Import Export Frameworks ability to export an entity. The DIXF currently supports 150 entities out of the box , and also provides the ability to create custom entities. To begin with, create a new processing group in the source system. Add the entity (or entities) to be exported to the processing group. Select Export to Ax Select an export location, file name and file format. This step will resemble the definition group export functionality. ...

Enable DB Compression in Ax 2012 with SQL 2012

Image
Database compression can be beneficial under certain circumstances. Ax 2012 supports enabling database  compression from within the application. See this blog post  for more details.This is quite handy. Unfortunately it only works with SQL 2008, not SQL 2012. The class SysSQLSetupHelper checks the SQL version and the controls on the form SysSQLSetup are enabled or disabled based on that. Luckily the fix for this is very easy - check whether the SQL version is 10 OR 11 (2008 OR 2012).