Modified objects between two AX 2012 databases

In case if you were wondering what are the modified objects between two AX 2012 databases (renamed, or deleted entries based on OriginId), we could use the Linked Server feature of Microsoft SQL Server to find out.

Our scenario was an AX 2012 RTM Feature Pack installation that is being upgraded to R3 version, and we wanted to find out which objects have been renamed or removed (either DEL_ prefix, or complete deletion) between the two instances with my colleague, Peter Prokopecz.

The solution was to open SSMS and under Server Objects > Linked Servers add a connection for the other SQL instance, then we could use the queries below to find out which are the modified objects between two AX 2012 databases of any versions.

Renamed_DB_objects

These are perfect for identifying for example enums, EDTs or tables which have been deprecated by Microsoft. If you want to use Version Control for your code upgrade, you could just branch off the original R1 version, rename the objects and then you would be able to keep the historical changes on those objects.

DAXRunBase / 2016-03-14 / AX 2012
Tags: , , ,

Comments

  1. Modified objects between two AX 2012 databases - Microsoft Dynamics AX Community

Leave a Reply

Your email address will not be published / Required fields are marked *