#Japan #Tokyo #Intech #Insight SQL Testing #AWS Migration

Intech’s Successful Database Migration to AWS

In an impressive display of technical prowess and innovation, Intech, a major player in entertainment services, has successfully migrated its extensive database to Amazon Web Services (AWS) without any service interruptions. This achievement is particularly remarkable given the scale of the operation, which involved the transition of a 5.3TB database that supports entertainment systems nationwide. The key to this seamless migration was the adoption of Insight Technology's SQL Testing software, known as Insight SQL Testing, which enabled thorough testing while maintaining live service operations.

Background of the Migration

As the entertainment industry evolves, the need for robust and scalable infrastructure becomes paramount. Intech, which provides a variety of entertainment options utilizing audio and visual technologies, recognized that transitioning its communication service systems to the cloud was essential for operational efficiency. The system in question processes a staggering 30 million transactions daily and must remain operational 24/7. With this level of demand, downtime for migration was simply not an option.

The existing system relied on Oracle Database 11g Enterprise Edition. The challenge was to move to Amazon RDS for Oracle (19c base) while ensuring that the transition was smooth and did not disrupt ongoing operations. Given the sheer volume of SQL queries involved, manual testing was not feasible. Therefore, Intech required a solution that could automate extensive testing without impacting performance on the production environment.

That's where Insight SQL Testing came into play. This software offers the capability to automatically collect SQL queries generated by applications in the live environment, facilitating comprehensive testing in a simulated environment. This approach proved crucial in addressing the stringent requirements set by Intech.

Achievements Through Insight SQL Testing

The implementation of Insight SQL Testing allowed Intech to complete the project successfully, and they highlighted several significant outcomes:

• - Rapid Project Completion: The project was completed in an astonishingly short timeframe. With just two engineers working for roughly two weeks, they were able to conduct extensive SQL testing. Including the final report submission, the overall process took less than a month.

• - Early Detection of Potential Issues: Insight SQL Testing played a pivotal role in identifying numerous errors that might have gone unnoticed during manual testing. It effectively flagged changes in SQL naming conventions, modifications to passwords for DB_LINK, and the absence of certain objects that could lead to operational failures during the upgrade from Oracle 11g to 19c.

• - Optimization of Infrastructure Costs: By evaluating SQL performance through testing, Intech was able to select the most suitable AWS instance types, leading to improved cost-effectiveness and operational efficiency.

Comments from Intech Executives

Masato Hasegawa, head of the Chubu and Western Japan Solutions Department at Intech, reflected on the experience, stating, "The adoption of Insight SQL Testing has enabled us to provide our customers with the invaluable assurance that their business would not be interrupted during migration. This tool is incredibly powerful and promises secure cloud transitions as our clients aim for a cloud-native infrastructure. We look forward to utilizing it continuously."

Similarly, Hirotaka Iida, an engineer from the same department, noted, "Utilizing Insight SQL Testing felt like having an expert database specialist join our team. It allowed us to conduct comprehensive SQL testing without impacting our services, preventing potential issues that could arise during the migration."

About Insight SQL Testing

Insight SQL Testing is designed to automate the assessment of SQL applications necessary for database migration and upgrades, thus significantly reducing workload costs. It is compatible with multiple databases, regardless of whether they are on-premise or cloud-based. The software collects SQL queries from currently operating databases and evaluates them in test scenarios.

For more information on Insight SQL Testing, you can visit their official product page here. It is also readily available for adoption on the AWS Marketplace.

About Insight Technology

Since its inception in 1995, Insight Technology has consistently pursued database technology to maximize the value of data for companies. They provide a solid foundation for utilizing data effectively through their products and professional services. Insight Technology also hosts the db tech showcase, a conference featuring global experts in data technology that attracts around 1,000 engineers annually.

For further details about Insight Technology, please refer to their website: Insight Technology. The company’s ongoing commitment to enhancing data governance solutions aids companies in harnessing their data strategically to achieve operational excellence.

For inquiries regarding this achievement, please contact the Marketing Department at Insight Technology via telephone at 03-5475-1450 or email at [email protected].