Fast detection of causes for the improper operation of the software product
The Case
Your company has finished the development of a software product working with a database. The QA department has carried out all the necessary checks and you have sent the product to the client.
However, the customer complains about a malfunction in the product. You have to identify the cause of operation failure and fix them as soon as possible. Eventually you realize that the cause of the problem is in the differences between the R&D environment and the customer's database. However, the search for the problem involved a considerable amount of resources and took a long time. This does reflect well on your company.
Main goals to be achieved
- Databases comparison
- Promptness and accuracy of the identification of differences between the tested databases
- Improvement of the support department's operational efficiency
- Accurate identification of differences between the tested databases
Our solution
Use Cross-Database Studio in order to compare R&D environment databases with the customer's database and generate SQL synchronization scripts:
1. Compare your R&D environment database with the consumer's production database in order to get a detailed report about the differences in table structures, primary keys, indexes, foreign keys, data (the list of the objects of comparison is defined by perforce);
2. Analyze the received reports with a view to the significance of the discovered differences. If the found differences between the databases are considerable - act to change the customer's database. In most cases several changes are sufficient to enable your software product to operate in a stable manner, without causing damage to the customer's database.
Advantage of our solution
· Dramatically reduces the time needed to detect the cause of the software product's improper operation, and as a consequence - significantly cuts the time for the localization of the software product at the customer's.
- The differences discovered between the compared databases are accurate, informative and undifferentiated.
- Improves the quality of the support department's operation and enhances the reaction speed on customer's requests and claims.
Dramatically reduces the time needed for the detection of causes of the software product's improper operation, and as a consequence - significantly cuts the time for the localization of the software product at the customer's.
|