While working on routine software development tasks, the company came to the conclusion that the standard Microsoft SQL Server Integration Services and Performance Monitor were not sufficient for their developers and did not provide the required standards and detailed information. They wanted to find a new solution that would help them achieve the following goals:
The company's consultant Steve Palmer introduced dbForge SQL Tools to the team, as he used them in his work before and found them highly reliable and user-friendly in daily operations.
One of the primary goals of SQL Tools in this particular case was compatibility with Excel spreadsheets. The tools allowed Steve's teammates both to retrieve data from the spreadsheets and operate with live data directly in Excel, modifying and subsequently saving it. The tool proved invaluable when it came to importing data to databases, synchronizing databases with applications, and migrating data to the cloud.