Fail-safe migration tool with a data integrity guarantee

Business need

Apart from the dispensing equipment Customer offers his clients accompanying software that is compatible with all the suggested automatic dispensers. For now, it has fulfilled operators and engineers needs for fifteen years. But as any software today it had to conform with ever-changing and fast developing technologies along with the new Windows versions upcomings. Therefore next edition of this product has been released. Yet it arose a new problem of data carrying over – clients had to upgrade the software without losing all the data including sales history and dispensing formulas. In order to meet this need of prime importance, it was decided to develop a tool that will save client’s data in prior to software upgrade and then carefully transfer it after installing the new version.

Solution

As the result of the effective collaborative work trouble proof desktop application has been developed for database migration and validation. Its simple and friendly interface made it easy to apply even for non-techy users.

Customer

Our customer is IDEX Scandinavian manufacturing company that produces paint dispensing and mixing equipment for the architectural coatings industry. Now it provides services to the broad spectrum of clients and its office’s network covers all the continents.

Challenge

  • To develop fail-safe migration tool that will guarantee data integrity.
  • To avoid the external libraries or frameworks installation to ensure simplicity of tool performance.
  • To design simple and localize interface understandable for most of the users.

Value Delivered

What was achieved:

  • by means of the offered last solution, it became possible for our Customer to modernize his approach without risks of massive data and credibility loss;
  • with the help of the proposed approach Customer fulfilled distinct needs of the wide international clientage showing his reliance and concern which in its turn resulted in its loyalty growth.

Technologies

Project Results

The final product of given project developed by Softarex Technologies, Inc. included two components: Converter and Clean-up tools. This approach made possible to cover both cases appeared among clients: some of them were aiming to upgrade their software along with the platform, and other were just willing to continue using old familiar version but with an updated database. The Converter tool met the requirements of the first group and comprised the following list of features:

  • database backup creation: At the first step tool created a data backup and provided it with the log file. This way data safety was insured;
  • database clean-up: Formulas containing no longer existing products, bases and components were removed;
  • database migration: All the processed data was carefully transferred to the new version database;
  • recording: The clean-up and migration process was logged in a neat and detailed way so on the chance of any failure customer would get an informative report with the full error description;
  • testing: Data integrity was checked with unit-tests after migration process had finished.

Clean-up tool was a personal application intended for the second group of clients. It allowed to validate the old version database and exclude all no longer existing formulations from it. By means of this tool, the user could skip version upgrade and continue using old software edition with refreshed database.

What our customers say

I’ve bеen working with Softarex for more than six years and three things were the cornerstones of our cooperation: quality, communication, and accessibility. These guys have always clearly understood all the functional specs I needed and gave me the best translation into the tech specs. All the databases were structured into the utmost flexibility – you can leave all the hardcoded stuff to the ancient times. Definitely 5 stars!

More +
Daan Hommes, MD, PhD
CEO at DEAR Health, Inc.

We hired Softarex Technologies, Inc. for a large, complex development project. They did an excellent job. The project was done on time and on budget. We continue to work them on new projects.

More +
Kevin Woodward
ReadyTech Corporation President

For all the time of working with Softarex Technologies, the difference between customer-contractor relations and partnership relations has become clear. That is exactly how this company builds the working process - you both (the company and its client) becomes partners. And it is not only to sign a contract, but it is also about negotiations, discussions, compromises, constant communication and joint decision making. Softarex will deliver its client a turn-key solution that exceeds all the expectations, all on time and within the budget. And after that, they will provide with a superior customer care that will maintain the relationships for years. Noventic provides devices and systems for the consumption-based collection and billing of water and heat and serves customers worldwide. Since 2010, various solutions in preparation of the internet of things (IoT) have been developed. For us, Softarex Technologies, Inc. has developed housing and public utilities solution - the future for energy suppliers. With the new system meter, readouts can be carried out at any time and fulfill upcoming regulations. The supplier can give transparency and thereby obtain trust from tenants and housing industries in the service. The team we’ve worked with earns praise for their timeliness, collaborative approach, and technical expertise. Their transparent clarifications minimize confusion and ensure clean high-quality deliverables.

More +
Thomas Ahlborn
Head of corporate marketing

We’ve been working with Softarex Technologies, Inc. team for over two years. These guys have brought us from the Stone Age to the Digital Age. Their team has developed the state-of-the-art billing and information management software for SYBE as well as web-based Clinic Management Software for SYBE's clients. Both solutions are at the cutting edge, meeting all the requirements and standards: ANSI 835, 837; Meaningful Use; HIPAA, HL 7 and ODBS compliant; ICD 10 Diagnostics, CPT/HCPCS, NDC numbers; CMS-1500 claims, etc.

More +
Steven Garrett
President of SYBE Medical Management

What I found extremely interesting in Softarex Technologies, Inc. it is the possibilities to use a wide range of technologies and each time get the same quality and time-requirement! I strongly suggest cooperating with Softarex Technologies!

More +
Carmine Mattera
IT Director at Artensys S.r.l.

Softarex Technologies, Inc. delivers “what” they promise, “when” they say they are going to complete a job and that is a great thing. Most business people “over promise” to get your money, and then they “under perform”. I appreciate your great work and professionalism. You have earned my trust! Keep doing what you are doing and you will build your business with great success.

More +
Marc R. Bakerman
President and Founder of The Child I.D. Program, Inc.

Request a quote

Or contact our Sales Team directly at +1 (703) 584 4399 (US), +44 121 288 9001 (EU)

Your message has been sent. Thank you!