ReleaseUpdateDB41_Administration.updateEPWebSiteParameters 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	ReleaseUpdateDB41_Administration
Method	updateEPWebSiteParameters
Description	This function copies data from the DEL_WebSite and DEL_EPParameters table to the EPWebSiteParameters table.

Affected Modules and Tables

Affected Modules
Administration

Affected Tables
EPWebSiteParameters
DEL_WebSite
DEL_EPParameters

Remarks

The DEL_WebSite has many company specific rows. The DEL_EPParameters has one row per company. The EPWebSiteParameters has many company neutral rows. The data from the DEL_WebSite table will be copied directly into the EPWebSiteParameters table and specific fields from the DEL_EPPParameters table will be duplicated across each entry. The EPWebSiteParameters table has the new CompanyIndependent field. This field indicates whether a website is associated with a company. The DEL_WebSite has the CompanyId field that contains the company ID of the company that the website belongs. As such, this field should never be empty and the CompanyIndependent will be set to No for all data that is transferred. Transfer all fields from the DEL_Website table. Transfer the EnableEncryption, EncryptionExpirationInterval, ImageResize, ImageSizeSmall, ImageSizeLarge, and ImageRatiomation fields from the DEL_EPParameters table.

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
EPWebSiteParameters

Deleted Tables or Fields

Table	Field
DEL_EPParameters
DEL_WebSite