Delete all transactions in AX 2012 database for upgrade from CU8 to CU13

(0) Share

Report

Posted on by Anudeep1806

Hello Team,

We are working on the Upgrade from AX 2012 R3 CU8 to AX 2012 R3 CU13. We have completed the code upgrade and our client does not want to do the data upgrade due to the huge size of the data.

As per the discussion with the client, they would like to use the data migration approach to move the certain data from CU8 to CU13 environment.

In addition to that client also would like to keep all the licenses (AX and partner feature set) from existing system as it is difficult to reach out to the ISV Vendors.

We would like to know if there is a way that we can clean up the database with all master data/ parameters and transactional data (Like blank DB) but keep the licenses as is in the DB. Once we have that DB ready, we will perform the data migration.

I saw that basically there are two tables SysConfig and SYSLICENSECODESORT tables where are the license are being stored.

All responses (1)

Answers (0)

André Arnaud de Cal... 293,140 Super User 2025 Season 1 on at

Like (0)

Report

RE: Delete all transactions in AX 2012 database for upgrade from CU8 to CU13

Hi Anudeep,

I have separated your question from the thread you responded to. The SysDatabaseTransDelete class can be used to delete transactions, but is not supported for production environments. Using it would be at own risk. For sure, you need to check the complete database after this action and clean up additionally where required. Note that the number sequences will not be reset. This job is also not deleting master data.

You can also try a new installation of the DB and try to copy the table contents of the SysConfig table with SQL scripts. Anyway, all efforts should be thoroughly tested.