VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Manual de usuario descargar pdf (Pagina 24)

ADM Repository Reference Guide

24 VMware, Inc.

Upgrading the External Database

Performthefollowingstepstoupgradetheexternaldatabase.

Upgrading for MS SQL

WhenupgradingtheexternaldatabaseforMSSQL:

1Optionally,recordtheScheduledTaskconfiguration:

aFromtheWindowsStartmenu,navigatetoSetting>ControlPanel>Scheduledtasksandopenthe

sync_adm_olaptask.

bRecordtheconfigurationforlateruse.

2 Deletethesync_adm_olaptask.

aFromtheWindowsStartmenu,navigatetoSetting>Control

Panel>Scheduledtasksandopenthe

sync_adm_olaptask.

b Right.clickthesync_adm_olaptaskandclickDelete.

3Ensurethatsynchronizationisnotcurrentlyrunningasfollows:

aLogintotheADMConsoleasadminuser.

bFromtheADMConsole,navigatetoConnectors>Reports>ExternalReportsSchemeIntegration

Status.

cIfSynchronizationStatus

indicatessynchronizationinprogress,waittillitcompletesandthen

proceedwiththeupgrade.

4ExecutethefollowingSQLscriptslocatedintheadm_olap/scheme/sqlserver folderusingthe

user/password adm_olap/adm_olap(Toexecute,double.clickthescript):

 drop_constraints.sql

 truncate_data.sql

 drop_tables.sql

5ExecutethefollowingSQLscriptslocatedintheadm_olap/scheme/sqlserverfolderusingauserwith

administratorpermissions(Toexecute,double‐clickthescript):

 drop_olap_schema.sql

 drop_database.sql

6 Backuptheoldadm_olapfolderthatincludesthesync.propertiesandsqlserver.propertiesfiles(It

containsyourconfigurationsettings).

7Proceedwiththeinstallationinstructionsin“InstallingandConfiguringtheExternalDatabaseforMS

SQL”onpage 20.

MPORTANTTheupgradeprocessrequiresacompleteuninstalloftheexistingdatabaseversionandan

installationofthenewdatabaseversion.

IMPORTANTThefollowingstepclearsthedataintheexternalreportdatabase.Thedataisrecovered

onceyouperformafullsynchronizationaftertheupgradeiscomplete.

EnsurethatSQLscriptsareassociatedwithSQLServerManagementStudiobeforecontinuing.

CAUTIONDonotcopythenewconfigurationfilesoverthebackedupconfigurationfiles.Usethebackedup

configurationfilesonlyasareferencetomanuallyupdatethenewfile.

1 2 ... 19 20 21 22 23 24 25 26 27 28 29 ... 43 44

Sin comentarios

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Manual de usuario Pagina 24