About the customer
Chan Chun Seong is a Data Architect at an outsourcing company that delivers business solutions and services
through state-of-the-art technologies and unique consulting approaches.
His company is a Microsoft Gold Certified Partner and has extensive engagements
and strong partnerships with organizations of all sizes and industries,
including finances, consumer goods and retail,
telecommunications, education, and high-tech manufacturing.
Country
Malaysia
Product used
Challenges faced
This story revolves around a software development company that frequently works with database-centered projects and wants to enhance the performance of its routine operations. They have been managing a variety of MySQL databases across multiple environments, with a focus on regular usage of stored procedures, custom functions and triggers.
But overtime a need arose to optimize their routine work. They had to sync all databases schemas manually, which became a tremendous scope of excessive work. Finally, a decision was made to employ a more advanced tool that would embrace customizable database comparison and synchronization.
01
Manual synchronization of multiple database schemas
02
Manual work with stored procedures, triggers, and custom functions
03
Slow identification and elimination of errors before deployment
The solution was found in dbForge Studio for MySQL, an all-encompassing integrated environment for MySQL and MariaDB databases. It was a definite level up in comparison with the tools that Chan Chun Seong's team had used previously—and the actual results did not keep them waiting.
"The automated schema comparison is the life saver in our environment. It helps us to identify any out-of-sync schemas and enables side-by-side comparison, which we are using to manage and compare business logics within the stored procedures.
I would also say it has cut down our DB deployment activities (from preparation to actual deployment) by more than 50%. And more importantly, now the system is able to compare all the changes, further eliminating human errors when we are preparing for deployment."
Data Architect
Results achieved
-50%
time spent on routine database deployment
+20%
overall productivity growth
dbForge Studio proved to be an invaluable tool for database management. Activities like schema and table design, query performance tuning, as well as schema and data comparison across multiple environments got an impressive boost in terms of speed and reliability. The chance and cost of human error were also greatly reduced. The entire workflow—development to staging to production—was effectively streamlined.
Key features Chan Chun Seong is excited about
Schema comparison
Failsafe comparison and synchronization of MySQL schemas was one of the main reasons why Chan Chun Seong's company adopted dbForge Studio. Even with complex object dependencies, the process remains simple. The Studio helps conveniently preview comparison results, detect possible errors early on, and generate synchronization scripts (more on that below).
Automated script generation
Chan Chun Seong's development team runs weekly sprints where they set deployment schedules for the upcoming week. dbForge Studio for MySQL helps them prepare almost instantly by auto-generating deployment scripts which remove the need for manual tracking of schema changes—the tracking that previously used to take several hours.
Environment categories
Operations with multiple databases and environments take lots of time and effort. To make things much simpler and faster, dbForge Studio offers a number of productivity enhancements, one of which is assigning colors to different environment categories. This makes navigation and switching between the required development, staging, and production databases extremely easy.
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of MySQL management software, tailored to your business needs and demands.
-
Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.
-
Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.
Similar stories
More success stories
SharingAlpha
"We needed a way to compare database schemas and your tool was the best on the market by all accounts..."
dbForge Studio for MySQL
Cashpoint Solutions
"dbForge Studio reduced manual work, consistency and integrity of data and schemas, saved time..."
dbForge Studio for MySQL
MACROPAGE
"I got all that in a single tool. dbForge Studio is — for me — the best MySQL client on this planet!"
dbForge Studio for MySQL