View blogs | Login

The Consultant's Burden

The life of the IT consultant who has multiple clients can be a complicated one. It's not up there with getting your clients to pay you, but keeping all the tools you need for your clients' systems, keeping them up to date and keeping them from conflicting with each other is a big pain.

Database tools can be the worst. All the major database management systems have their own client tools which, especially for developers, can weigh your system down. Imagine having to have the MySQL tools, the Oracle tools, the Microsoft SQL Server tools, the IBM DB2 tools and maybe even others on your laptop.

This is true very often of in-house IT staff. Acquisitions, changing IT leadership and the passage of time can result in an environment in which multiple database solutions are used for different applications. Messing with a working application just isn't worth the risk, but it still leaves you with an administrative mess.

ODBC is the answer. ODBC is one of those standards that has been around for so long that nobody remembers what it stands for: Open DataBase Connectivity. It goes back over 25 years, making it an established part of the database landscape.

Synametrics WinSQL relieves the consultant's burden by using ODBC to provide powerful database management features to just about any database platform. It's ideal for importing, exporting and migrating data between platforms. This flexibility and power is why WinSQL is used by 90% of Fortune 1000 companies and over a million programmers and DBAs across the globe.

Version 10 of WinSQL adds entity relationship (E/R) diagrams that are part of the database system catalog. This greatly eases documentation and analysis of databases. The new version is 100% Unicode compatible and supports both 32- or 64 bit drivers.

Some think of ODBC as suboptimal, a compromise that will perform badly and drop important features, but this is the wrong way to look at it. You might not want to use ODBC for production access to databases, but it performs well for administrative tasks, and WinSQL 10 adds significant performance enhancements over previous versions.

ODBC functions can be used for the large majority of database administration, creation and testing. But for proprietary functions not supported in ODBC WinSQL provides plugins for many database management systems, including Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL and others. Plugins allow for:

  • Retrieving scripts for Views, Triggers, Stored procedures
  • Generating DDL scripts for tables
  • Database specific objects such as sequences, functions, rules, and check constraints
  • Database specific syntax for creating indexes
  • Configuration information from the server
But it's really the convenience that makes WinSQL essential for IT and database consultants. No matter what database management system you're using, no matter the version, you can work with it in the same tool.




Created on: 2/17/16 3:08 PM
Last updated on: 2/17/16 3:08 PM

Navigation

Social Media

Powered by 10MinutesWeb.com