ReleaseUpdateDB60_Retail.allowDupRetailConnTablesIdx Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_Retail

Method

allowDupRetailConnTablesIdx

Description

Updates the NameIdx index in the RetailConnAOSProfile table to allow duplicate records. Updates the ProfileIdx index in the RetailConnAOSProfile table to allow duplicate records. Updates the NameIdx index in the RetailConnConnectionProfile table to allow duplicate records. Updates the NameIdx index in the RetailConnCustomConnectionProfile table to allow duplicate records. Updates the ProfileIdx index in the RetailConnCustomConnectionProfile table to allow duplicate records. Updates the NameIdx index in the RetailConnDatabaseProfile table to allow duplicate records. Updates the ProfileIdx index in the RetailConnDatabaseProfile table to allow duplicate records. Updates the groupIdx index in the RetailConnDistributionGroup table to allow duplicate records.

Affected Modules and Tables

Affected Modules

Retail

Affected Tables

DEL_RETAILCONNCHILDLOCATIONS

DEL_RETAILCONNDISTRIBUTIONINCEXCLIST

DEL_RETAILCONNINITIALREPLICATIONCOUNTER

DEL_RETAILCONNSCHEDULERJOBTYPE

RETAILCONNAOSPROFILE

RETAILCONNCONNECTIONPROFILE

RETAILCONNCUSTOMCONNECTIONPROFILE

RETAILCONNDATABASEPROFILE

RETAILCONNDISTRIBUTIONGROUP

RETAILCONNDISTRIBUTIONGROUPMEMBER

RETAILCONNDISTRIBUTIONLIST

RETAILCONNDISTRIBUTIONLOCATION

RETAILCONNDISTRIBUTIONSUBGROUP

RETAILCONNDISTRIBUTIONSUBLOCATIONTABLE

RETAILCONNPARAMETERS

RETAILCONNPREACTIONLOG

RETAILCONNSCHEDULERDISTRIBUTIONFILTER

RETAILCONNSCHEDULERLOG

RETAILCONNSCHEDULERREPLICATIONCOUNTER

RETAILCONNSTORECONNECTPROFILE

RETAILCONNSTORECONNECTUPLOADOPTIONS