WinSQL

RATING:

4.5

(29)

About WinSQL

WinSQL is a database management solution that helps businesses streamline operations related to data migration, schema comparisons, task scheduling, offline backups and more on a centralized platform. It enables employees to use a drag-and-drop interface to handle data import and export processes in multiple file formats. WinSQL comes with WYSIWYG SQL wizards, which let data analysts manage code scripting operations using syntax highlighting, auto-code completion and built-in hotkeys, among other tools. The designing tools enable staff members to draw E/R diagrams, view relationships among tables and pull scripts for triggers and stored procedures. The administrative dashboard enables users to update statistics, handle data backups, create new users and generate da...

Awards and Recognition

FrontRunner 2020
Software Advice's FrontRunners report ranks top products based on user reviews, which helps businesses find the right software.

WinSQL Pricing

Lite : Free Standard : $99 Professional : $249

Starting price: 

$99.00 per year

Free trial: 

Available

Free version: 

Available

WinSQL offline restore wizard
Slide 1 of 4

WinSQL Reviews

Overall Rating

4.5

Ratings Breakdown

Secondary Ratings

Ease-of-use

4.5

Customer Support

4.5

Value for money

4.5

Functionality

4

Most Helpful Reviews for WinSQL

1 - 5 of 29 Reviews

User Profile

Deepak

Verified reviewer

Information Technology and Services, 10,000+ employees

Used daily for less than 6 months

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

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.

PROS

1. Easy to connect to different databases like db2, oracle etc. 2. Easy to get reports and extracts out of databases. 3.Light-weight application

CONS

1. 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

Review Source: Capterra

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.

PROS

Among 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!

CONS

About 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

Review Source: Capterra

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.

PROS

Easy to use, good catalogue of objects, but this has caused massive problems

CONS

WinSQL 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

Review Source: Capterra

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.

PROS

I 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.

CONS

The 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

Review Source: Capterra

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.

PROS

Very easy to setup to and use just about any database connections you’d need.

CONS

The 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