About the customer
Allspoke is a software development house specialising in retail, hospitality and service solutions. It is the developer of the Ramsys Retail Management System and the Business Objects application. They also provide website design and development services, custom programming and data manipulation services, management and support with IT manager/CIO type support or retail consultation for companies trying to improve or develop an IT footprint as well as custom application development.
Country
New Zealand
Product used
Challenges faced
When a company is diverse and busy enough to deliver software development services and at the same time evolve and market a retail management system, process automation is a necessity. And when it comes to databases—which constitute a vital part of their custom products—automation would allow shifting the focus to more attention-demanding things and solve several pressing challenges at hand:
01
Legacy databases had to be effectively moved to MySQL
02
Synchronization of database structures was time-consuming
03
The functionality of other tools was insufficient
After quite a few tools were tried and tested—the Allspoke team were even about to start developing their own database management solution—Mark Stratton, the company's CTO, came across dbForge Studio for MySQL. It became evident from the beginning that it was the solution they were looking for.
"Database design and maintenance are much easier now, saving us many man-hours every day. Schema syncing is very simple. dbForge Studio has the best feature set and is more reliable than any other tool we were using."
CTO/Director at Allspoke LTD
Results achieved
+35%
increased productivity for all database-related operations
Database design, structure management and updates, query building, schema backup and recovery—all of these routine operations were streamlined with the help of the Studio over a short period of time. Several features were mentioned by Mark as especially useful.
Key features Mark is excited about
Database Designer
The built-in Database Designer provides users with database diagrams,
which let them create, analyze, reverse-engineer, print, and customize MySQL databases.
Additionally, these diagrams allow viewing foreign key relations,
displaying database objects with properties, and executing stored procedures.
Visual query building
Query Builder is another integrated tool that simplifies the creation of MySQL queries
on visual diagrams, which means there is no need for SQL coding.
With its help, users can build, group, and arrange complex tables, create JOINs,
as well as add and modify conditions using an intuitive drag-and-drop interface. The same functionality is available separately in an application called Query Builder for MySQL.
Schema synchronization
The schema comparison and synchronization functionality—available both in dbForge Studio
and in a standalone tool Schema Compare for MySQL—is an invaluable assistant when it comes to
comparing database schemas of any size, locating and analyzing the differences,
and setting up safe deployment. Generation of migration scripts and comparison reports
is also included.
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 storiesCreative Memories
"We became 25% more efficient as we saved 2 FTE hours per day and re-allocated them to project work."
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