Browse Prior Art Database

System and Method of Creating a Snapshot of Server Diagnostics during a Crash

IP.com Disclosure Number: IPCOM000131893D
Publication Date: 2005-Nov-21
Document File: 2 page(s) / 10K

Publishing Venue

The IP.com Prior Art Database

Abstract

Data on a server database may be changed whenever there is some interaction through either the mobile device manager on a computer, its services, or the mobile device. Analyzing server database changes is a tedious task, and often it is hard to find out what is going in there. It is not easy to understand, as there are multiple tables that dynamically change for different reasons. It is impossible to write such a spec document that could explain what will exactly occur in the server database

This text was extracted from a Microsoft Word document.
This is the abbreviated version, containing approximately 58% of the total text.

SERVER SNAPSHOT

System and Method of Creating a Snapshot of Server Diagnostics during a Crash

Disclosed Anonymously

Data on a server database may be changed whenever there is some interaction through either the mobile device manager on a computer, its services, or the mobile device. Analyzing server database changes is a tedious task, and often it is hard to find out what is going in there. It is not easy to understand, as there are multiple tables that dynamically change for different reasons. It is impossible to write such a spec document that could explain what will exactly occur in the server database

Server Snap utility is an excel application that tracks and reports any change that occurs in the database between two different states. Server Snap can connect to SQL Server, then take the records from specified tables (or all of them) in the separate spreadsheets. At that moment, the user (tester or developer) can perform any actions on the server. As soon it is completed, Server Snap can collect the second data snap and compare with first one taken earlier.

Server Snap reports any differences found in the captured records, for example:

    - changed values         (changed)

    - all new records         (new1, new2 ....)

    - all deleted records    (deleted1, deleted2 ...)

    - reported changes (a hyperlink to the table field where it was found)

 

Changes are coloured differently (easy to spot when there is lots of data).

Tables data in...