Tremendous time acceleration of software failure detection

The Case

Your company has finished development a product working with a database. Department QA has made all necessary checks and you have sent a product to the client. However the client complains that the product works not correctly, or some functions are absolutely does not working. Now you have to find the reasons of malfunction in the shortest terms and to eliminate them.

The search for such reasons usually demands significant efforts of whole product department and a plenty of time. Eventually you understand that the reason of the arisen problems consists in distinctions between a development database and a production database of the client. However search of these distinctions can demand also attraction of significant resources on long time interval. All this not is reflected by the best image in your company.

Main goals to be achived

• Comparison of databases.
• Fast and precise identification of distinctions between checked databases.
• Improvement the efficiency of work of a support department.
• Accuracy and correct definition of fixation of distinctions between checked databases.

Our solution is

Use Cross-Database Studio 6.0 to compare the development and released databases versus production environment and generate SQL scripts of synchronization:

1. Compare yours a development database versus production database of the client with the purpose of reception of the detailed report on the found out distinctions in table structures, primary keys, indexes, foreign keys, data (the list of objects of comparison are defined necessarily);
2. Analyze the received reports for dramatic character of the found out distinctions. If the found out difference between databases is critical - take steps on change of a client database. In most cases a little data changes will allow you do not break the databases robust and bring your software product to work qualitatively and stably as required.

Advantage of our solution

• Considerably decreases time of search for the reasons of software failure and as consequence - considerably decreases time of introduction your software product at the client.
• The found out distinctions between compared databases are exact, informative and standardized;
• Work quality of a support department is improves and efficiency of reaction to client requests are raise.