WinSQL
About WinSQL
Awards and Recognition
WinSQL Pricing
Lite : Free Standard : $99 Professional : $249
Starting price:
$99.00 per year
Free trial:
Available
Free version:
Available
Most Helpful Reviews for WinSQL
1 - 5 of 29 Reviews
Deepak
Verified reviewer
Information Technology and Services, 10,000+ employees
Used daily for less than 6 months
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
4
Reviewed February 2020
Handy and light weight database administration tool
I started using winsql so as to connect multiple databases like oracle and db2.I required to configure odbc in order to make it work. Overall it was satisfactory to work on it.
PROS1. Easy to connect to different databases like db2, oracle etc. 2. Easy to get reports and extracts out of databases. 3.Light-weight application
CONS1. Connection through IP address is not possible. 2 .It is not available for Mac OS 3. Sometimes it hangs and closes automatically during heavy queries.
Danny
Accounting, 2-10 employees
Used weekly for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
FUNCTIONALITY
5
Reviewed February 2019
Awesome Database Tool
I have been using WinSQL for many years, and unlike people, it just gets better with age. I'm a big believer in the product, and it has always performed very well regardless of which DB I'm using. It is a great tool for prototyping, development and production platforms. It has way more features than any of the free DB-specific browser/query tools, and now it even has its own data specific plug-in ODBC drivers. As a developer, having one tool to master and use against a variety of DB products, has saved me many hours over the years that I could put toward other phases of development instead of spending time on DB schema, query, stored procedure building and other issues. As an end-user tool, I have never found anything users liked better than WinSQL. Because of its ease of use, it takes the fear of complexity out of learning to use a query and reporting tool.
PROSAmong the many great features of WinSQL, the one that stands out the most is it ease of use. From setting up a DSN to creating and executing a query, WinSQL makes it so easy that I have been able to quickly train non-IT users how to run their own queries and reports. By enabling users to do so much with the tool, it really reduces the requests and workload for IT. Its ease of use also means new developers have a tool they can use to quickly check DB results from running their development programs in a test mode, or to quickly populate a table with test data to use for testing their program's DB I/O, either using WinSQL's Test Data Generation Wizard, or simply writing a quick INSERT group of records, and doing it manually. It is such a versatile tool with so many great features, it is hard to say which is my favorite. It all depends on what I'm doing in my development work, then whatever WinSQL feature I'm using, becomes my favorite. That is what makes it such an awesome database tool, its breadth of features!
CONSAbout the only thing I don't find very useful is the Task Scheduler. That is only because I have always used a different scheduler. So it isn't that I like it the least, it is just the feature I use the least. I can't think of anything I don't like about the tool.
John
Broadcast Media, 10,000+ employees
Used more than 2 years
OVERALL RATING:
1
EASE OF USE
5
VALUE FOR MONEY
3
CUSTOMER SUPPORT
3
FUNCTIONALITY
3
Reviewed February 2019
WinSQL is now banned on SAP IQ
It’s a shame we had to ban it. Although very slow to start on a large Datawarehouse, it had a good user interface and searching for objects was better than the tools provided by SAP.
PROSEasy to use, good catalogue of objects, but this has caused massive problems
CONSWinSQL on SAP IQ multiplex with 60,000 objects has been causing significant degradation in performance. The background refresh even caused outages on busy days. Since it was banned, we have seen performance gains and stability of the IQ service has improved.
Nathaniel
Utilities, 1,001-5,000 employees
Used daily for more than 2 years
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
5
FUNCTIONALITY
4
Reviewed February 2019
WinSQL is a great tool for developing web tools
During the 30 day trial, I was able to use the full version and I could do pretty much anything I needed to, including being able to explore the server stored procedures and find logic problems our vendor had introduced when programming the database. Currently, I still use it daily to pull information and compile reports and am very satisfied with it's performance.
PROSI like that WinSQL has all the features needed to find information in most databases even if using the free version. I use it to connect to an Informix server while MS SQL server manager will not.
CONSThe restriction to a single server connection in the free version is an annoyance, but I understand it's incentive to purchase the full version.
Shane
Financial Services, 11-50 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
4
FUNCTIONALITY
4
Reviewed February 2019
Excellent, flexible SQL query tool
This is my go-to SQL query tool, and has been for many years. It does what it says. I do wish there were some better options for interface colors or theming, but it works well without that.
PROSVery easy to setup to and use just about any database connections you’d need.
CONSThe interface looks a bit dated. If there are any auto-formatting features for sql code I haven’t found them. A mini-map for larger queries would also be helpful.
Vendor Response
Auto-formatting feature will be available in the upcoming version 12.
Replied March 2019