- en
- es
Log de Cambios Versión 3.2.2.24.24
- Se contempla la migración desde la versión 3.2.2.24.19
- Realizar la actualización de personalizaciones, cualquier cambio en los SQL debe implmentarse en los archivos correspondientes de la nueva versión.
Después de actualizar los archivos de Software y los sitios, realizar las siguientes actualizaciones de base de datos con el SetupBox1).
- En SetupBox > Módulos > Común
Para la versión 3.2.2.24.24 desde la versión 3.2.2.24.1f no existen actualizaciones, sin embargo, se recomienda verificar si existe alguna pendiente de migraciones anteriores. Dar clic en Check Upgrade
- Para actualizar la versión en base de datos:
Dar clic en Apply Upgrade.
- Habilitar la casilla Full Update para incluir los pasos de verificación de archivos .cfg y tablas/campos
- En caso de no activar la casilla Full Update se van a realizar unicamente las actualizaciones de versión pendientes
Resumen de verificación y actualización de los service pack-------------------- Build BDD Basic----------------------- Generate:Common Generate:SetupBox Generate:DataLink Generate:CMDB Generate:Atis Generate:DRobot Generate:Demo -------------------- Verify BDD Basic----------------------- Create BDD:Common Create BDD:SetupBox Create BDD:DataLink Create BDD:CMDB Create BDD:Atis Create BDD:DRobot Create BDD:Demo -- Interno Service Prefix[Common] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[SetupBox] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[DataLink] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[CMDB] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[Atis] BDD[mdf] -- YES NEW_TABLE TABLE:SDCASE_INPUTEMAIL FIELD:IDSDCASE_INPUTEMAIL SQL:CREATE TABLE SDCASE_INPUTEMAIL ([IDSDCASE_INPUTEMAIL]INTEGER IDENTITY(1,1), CONSTRAINT IDSDCASE_INPUTEMAIL1 UNIQUE ([IDSDCASE_INPUTEMAIL])) YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:IDSDCASE SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [IDSDCASE]INTEGER YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:EMAIL_DATEIN SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DATEIN]DATETIME YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:EMAIL_SOURCE SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_SOURCE]VARCHAR(255) YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:EMAIL_SUBJECT SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_SUBJECT]TEXT YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:EMAIL_DESCRIPTION SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DESCRIPTION]TEXT YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:EMAIL_DESCRIPTION_BA SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [EMAIL_DESCRIPTION_BA]VARBINARY(MAX) YES NEW_COLUMN TABLE:SDCASE_INPUTEMAIL FIELD:IDSYSTEMSTATUS SQL:ALTER TABLE SDCASE_INPUTEMAIL ADD [IDSYSTEMSTATUS]INTEGER YES NEW_COLUMN TABLE:SURVEYDATAUSER FIELD:SURVEYDATAUSER_DATEVOTE SQL:ALTER TABLE SURVEYDATAUSER ADD [SURVEYDATAUSER_DATEVOTE]DATETIME YES NEW_TABLE TABLE:SURVEYDATAUSERLOG FIELD:IDSURVEYDATAUSERLOG SQL:CREATE TABLE SURVEYDATAUSERLOG ([IDSURVEYDATAUSERLOG]INTEGER IDENTITY(1,1), CONSTRAINT IDSURVEYDATAUSERLOG1 UNIQUE ([IDSURVEYDATAUSERLOG])) YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:IDSURVEYDATAUSER SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [IDSURVEYDATAUSER]INTEGER YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:IDSURVEYOPTION SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [IDSURVEYOPTION]INTEGER YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:SURVEYOPTION_NAME SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYOPTION_NAME]VARCHAR(50) YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:SURVEYOPTION_DESCRIPTION SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYOPTION_DESCRIPTION]TEXT YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:SURVEYDATAUSER_COMMENTARY SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYDATAUSER_COMMENTARY]TEXT YES NEW_COLUMN TABLE:SURVEYDATAUSERLOG FIELD:SURVEYDATAUSER_DATEVOTE SQL:ALTER TABLE SURVEYDATAUSERLOG ADD [SURVEYDATAUSER_DATEVOTE]DATETIME -- Interno Service Prefix[DRobot] BDD[mdf] -- YES NEW_COLUMN TABLE:DREMAILNEWCASEDETAIL FIELD:REPONSEEMAIL SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL]BIT YES NEW_COLUMN TABLE:DREMAILNEWCASEDETAIL FIELD:REPONSEEMAIL_START SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL_START]VARCHAR(50) YES NEW_COLUMN TABLE:DREMAILNEWCASEDETAIL FIELD:REPONSEEMAIL_END SQL:ALTER TABLE DREMAILNEWCASEDETAIL ADD [REPONSEEMAIL_END]VARCHAR(50) -- Interno Service Prefix[Demo] BDD[mdf] -- changes were not in the database. -------------------- Build BDD Extra----------------------- Generate:CIExtraTable Generate:ServiceExtraTable Generate:BaseLine -------------------- Verify BDD Extra----------------------- Create:CIExtraTable Create:ServiceExtraTable Create:BaseLine -- Interno Service Prefix[CMDB_EF] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[ST] BDD[mdf] -- changes were not in the database. -- Interno Service Prefix[BL] BDD[mdf] -- changes were not in the database. -------------------- apply service pack ----------------------- UpGrade Service pack completed Service OK: 0 Service Error: 0 -------------------- Upgrade Model ----------------------- [Actualización de modelos]
1)
Modulo para administrar conexión con motor de base de datos