VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Instrukcja Użytkownika Pobierz pdf (Strona 24)

ADM Repository Reference Guide

24 VMware, Inc.

Checking the Status of the External Database Load Process

Usethefollowinglogfilestocheckthestatusoftheloadprocesstotheexternaldatabase:

 ForOracle,check:/

unzip_path

/adm_olap/load/oracle/log

 ForMS‐SQL,check:

unzip_path

\adm_olap\load\sqlserver\log

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.

bRight‐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).

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.

1 2 ... 19 20 21 22 23 24 25 26 27 28 29 ... 41 42

Komentarze do niniejszej Instrukcji

Brak uwag

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Instrukcja Użytkownika Strona 24

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie bazy danych VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY