The last step in the process is to validate the size of some key tables, using the following details.
Database Name | sys.tables, sys.indexes, sys.partitions, sys.allocation |
Query | SELECT t.NAME AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id WHERE t.NAME NOT LIKE 'dt%' AND i.OBJECT_ID > 255 AND i.index_id <= 1 GROUP BY t.NAME, i.object_id, i.index_id, i.name ORDER BY sum(p.rows) DESC |
Once the next button is pressed the following screen will be displayed
...
This screen will list the available Ports/Upgrades that have previously been downloaded.
This will make a call to the following folder, filtering on the file extension *.wmsu
C:\Program Files (x86)\DATASCOPE\DATASCOPE WMS System Manager\Download
Once the next button is pressed the following screen will be displayed.
...
The screen will extract the selected Port/Upgrade into the following directory.
C:\Program Files (x86)\DATASCOPE\DATASCOPE WMS System Manager\Download\Temp
Once the next button is pressed the following screen will be displayed.
...
This screen simply warns the operator that the system will be shut down upon clicking.
Next. There is no external communication or integration on this screen.
Once the next button is pressed the following screen will be displayed.
...
The integration on each step in the above screen is mentioned in detail below.
<previous link>
<next link>
...