Implementation Tasks

Infrastructure Components

•  K:\ISAPPS\dsg\DevelopmentTechnology\tad_diags\EST072\Technical_Architecture.docx

Application Components

SQL DB

 DYNAMATplus (inc DBIPGet)

 MeterRingMM

SyncBack

Optima ADC

MS Outlook/Access

Application Setup

SQL DB

Get backup of existing DB and copy to new BD server (sql-dl-kb1t)

on new DB server right click databases > restore database > from device and browse to the .bak file. Once selected, the Database name should be available in the dropdown list in the top "to database" field. check the paths of the restore and that the filenames are correct,then go. The 'Dynamat_program' & 'meterringmm' DB user account will become orphaned by the move, these accounts can be recreated using infokeep details.

Dynamat_Edinburgh: In general check the collation is the same type as the existing DB. In Files check the logical name is correct and the path and file names are also corrrect. In options,  change the compatibility level to sql 2008

Back in File the DB owner will be blank to set this do the following: select security > logins > new login enter the "Dynamat_program" username and password(found in infokeep) remove the 3 checkboxes "enforce password policy" etc set database to Dynamat_Edinburgh and leave language as default. right click DB > properties > files > "..." and add the newly created user.

Mringmeterdata In general check the collation is the same type as the existing DB. In Files check the logical name is correct and the path and file names are also corrrect. In options,  change the compatibility level to sql 2008

 DYNAMATplus

https://www.wiki.ed.ac.uk/display/insite/Energy+Office+Software and follow the Dynamat Installation link upto procedure 32.

dynamat recommend that the application is not installed in the default program files folder.

https://www.wiki.ed.ac.uk/display/insite/Energy+Office+Software and follow the Dynamat Configuatation link

part 2.2. Lantornix can be skipped as this is no longer in use.

  MeterRingMM

 Existing install files are stored in the MeterRing e:\downloads\MeterRingMMver4.037 folder

Software Install: copy this folder to the new server and run the setup.exe to run through the default installer. the installer will complain that newer files already exist on the system, select the option to keep the new files. the installer will then complain about not being able to register a dll. select the Ignore and continue option. (note: i called the supplier of meterringmm  about these errors and their engineer was happy that this is the norm for thier installer).

copy the following files from the existing install folder over to the new server: SQL folder MRing.lic mring.ini MRing.mdb mringalarms.mdb mringexternalraw.mdb mringmeterdata.mdb

upon first run MeterRingMM will require registration, to do this call Elcomponent on 01279 503173 (i spoke to gary), give them the ID number and they will give a registration number back.

****************** Changing the Mring.ini file

MeterringMM pull its setup information from the mring.ini file, this need to be re-configured for the new server. Open the .ini and check that all filepaths are correct and point to files\folders within the MeterRing MM folder. resave the ini if any changes were required. close the ini file.

Encrypted MeterDataConnectionString: (used to protect the sql username & password) copy the mring.ini file from the application folder to the sql subfolder. run MRingMeterDataSQL.exe select "Use INI file entry" Enter server name: sql-db-kb1t database:  mringmeterdata check "sql server authentication" checkbox Enter Username (in infokeep) Enter Password (in infokeep) check "Use INI file entry" save to INI file then save Encrypted to INI file. check the "MeterDataConnectionString" is encrypted(no clear username or password) within the INI file copy the mring.ini file back into the root MeterRing MM application folder.

******************* Users desktop reconfiguration

To enable the users desktop to point to the new server, the local mring.ini needs updated. Firstly check that the user can connect to the server share \\meteringt\MeterRingMM$ If this connecion works change the below lines in the users mring.ini file to point to the new server. note the encrypted MeterDataConnectionString will need to be copied form the mring.ini file on the server.

copy of client PC Mring.ini content: [General] version=4.037 OverWriteData=False SystemIntervalMins=30 TimeZone=GMT Standard Time SysDataBaseFile=\\meteringt\MeterRingMM$\mring.mdb MeterDataBaseFile=\\meteringt\MeterRingMM$\mringmeterdata.mdb ExternalDataBaseFile=\\meteringt\MeterRingMM$\mringexternalraw.mdb [Comms] mscount=12000 [DBConnections] MeterDataConnectionString=6AB759E8D437E93.......(string data needs copied from server ini file).

SyncBack & Optima ADC

installed by Charlotte from optima, (was basically a copy of folders from existing live)

 MS Outlook/Access

Deselect all other applcations when running through the Office installer, selecting the default install options for Outlook and Access.

Integration Components

 N/A

Data Population

 N/A

Data Migration

 see SQL BD under Application setup section

Implementation Validation

Estates & Building user to compare data and run through test plan.