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


Read More

Supported Operating System(s):

Web browser (OS agnostic)

29 Reviews of WinSQL

Average User Ratings

Overall

4.45 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.5

Functionality

4.0

Ratings Snapshot

5 stars

(16)

16

4 stars

(12)

12

3 stars

(0)

0

2 stars

(0)

0

1 stars

(1)

1

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 29 results

February 2020

Deepak from FIS

Verified Reviewer

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

4.0

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.

February 2019

Danny from EIDL, Ltd.

Company Size: 2-10 employees

Industry: Accounting

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Functionality

5.0

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.

February 2019

John from Aky

Company Size: 10,000+ employees

Industry: Broadcast Media

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

3.0

Customer support

3.0

Functionality

3.0

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.

February 2019

Nathaniel from Montana-Dakota Utilities

Company Size: 1,001-5,000 employees

Industry: Utilities

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Functionality

4.0

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.

February 2019

Shane from Knoxville Teachers Federal Credit Union

Company Size: 11-50 employees

Industry: Financial Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Functionality

4.0

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.

Response from Synametrics Technologies

Replied March 2019

Auto-formatting feature will be available in the upcoming version 12.