Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support teams Worldwide

AX2012 Upgrades - Setting a clean AX2012 database to start with the upgrade check-list and not the Initialization check-list.

AX2012 Upgrades - Setting a clean AX2012 database to start with the upgrade check-list and not the Initialization check-list.

Rate This
  • Comments 3

As some of you who work on AX 2012 Upgrades may already know, you need to select the AOS along with the Database option in the AX setup to get the “Register this database for Upgrade” option.

However, if you already have an AOS service installed and want to setup a new database for an upgrade, sometimes you don’t want to install another AOS just to do get this option. If this is the case, you can run the following script as a workaround to modify the database after the install, so that the upgrade checklist is shown when you start the client:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[SETUPVERSIONPROC] AS SELECT '6.0.947.0'

GO

DELETE FROM SysSetupLog

WHERE NAME = 'SysCheckList_Setup'

OR NAME LIKE 'SysCheckList_Up%'

 

The statement creates the required stored procedure for the SysCheckList classes to identify this is an upgrade database, and in case you have already started the initialization check-list,  it also removes any previous records from SysSetupLog.

As with any direct updates to the database, it is recommended that you make a backup so you can restore the database if required. Also, only use this on a newly installed database!

 

Regards, Tom

Leave a Comment
  • Please add 6 and 3 and type the answer here:
  • Post
  • If upgrading from 4.0 or 2009 to AX 2012 R2, you also have to switch to table-per-type table inheritance mode (see Data Upgrade Best Practices (White Paper) for details, technet.microsoft.com/.../hh781082.aspx). To do so, you have to create one more stored procedure in addition to that mentioned above:

    CREATE PROCEDURE [dbo].[TABLEPERTYPEINHERITANCEMODE] AS SELECT 1

    GO

    Regards,

    Maxim

  • Is there any way to do it the other way around? I have checked the option "register the database for upgrade" during setup but I do not want to run any of the upgrade checklists so I want to remove the "register the database for upgrade" option. Is that possible or do I have to reinstall the database and AOS?

  • Hi Johan,

    You could try dropping the Stored Procedure "[dbo].[SETUPVERSIONPROC]". This is only created when you select the option "register the database for upgrade". If this is not present it will assume that this is a fresh install and not for an upgrade. You may also need to run the DELETE statement above on the SysSetupLog table. I've not tested this, but from what I found when looking at this in the past, I believe it should work.

    Thanks, Thomas

Page 1 of 1 (3 items)