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

[Blog bot]

Источник: http://blogs.msdn.com/b/axsupport/ar...heck-list.aspx
==============

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




Источник: http://blogs.msdn.com/b/axsupport/ar...heck-list.aspx

[Maxim Gorbunov]

Если вы апгрейдитесь на AX 2012 R2, в дополнение к вышесказанному нужно ещё переключить режим работы с наследованием таблиц в Table-Per-Type (по умолчанию в R2 он Table-Per-Hierarchy; подробности здесь - http://technet.microsoft.com/EN-US/l.../hh781082.aspx). Для этого кроме SETUPVERSIONPROC нужно создать в базе ещё вот такую процедуру:

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