The developers of The IT Service were building databases for their clients using SQL Server and Azure SQL. The main issue was to keep the live databases and databases in development synchronized. The standard tools offered by the default SSMS IDE did not provide the required functionality.
After trying several third-party solutions, Mr. Andrew Richards, the Managing Director of the company, chose the dbForge SQL Tools package for its easiness of use, functionality, and value for money.
The developers use SQL Complete, Schema Compare, and Data Compare almost every day. The tools help them create copies of the client databases "as live" in seconds. Also, they enable the developers to make changes to the dev copies, secure them all in the knowledge base, and push the updates to production without missing any detail.
The Documenter tool allows the team to keep documentation up to date, both at the column level and across objects. Besides, SQL Complete allows the team to make the code robust, accurate and quickly delivered.
As a result of the dbForge SQL Tools implementation, the company could improve the most demanding routines to get rid of errors, ensure precise performance, and gain much better speed of work.