Who Uses This Software?

Bank, Insurance, Healthcare

Average Ratings

24 reviews
  • Overall 4.3 / 5
  • Ease of Use 4.5 / 5
  • Customer Service 4.2 / 5
  • Features 4.2 / 5
  • Value for Money 4.6 / 5

Product Details

  • Starting Price US$99.00
  • Pricing Details Lite : Free Standard : $99 Professional : $249
  • Free Version Yes
  • Free Trial Yes
  • Deployment Installed - Windows
  • Training In Person
    Webinars
    Documentation
  • Support Business Hours
    Online

Vendor Details

  • Synametrics Technologies
  • http://www.synametrics.com
  • Founded 2002

About WinSQL

A homogeneous solution for a heterogeneous environment. It is a data base administration and development tool that allows multiple databases to communicate with one another in one central location.

WinSQL Features

  • Data Discovery
  • Data Visualisation
  • High Volume Processing
  • Predictive Analytics
  • Regression Analysis
  • Sentiment Analysis
  • Statistical Modeling
  • Text Analytics
  • Abbreviation Detection
  • Data Capture and Transfer
  • Data Duplication
  • Data Entry Verification
  • Data Retrieval
  • Image Capture
  • Mis-Keyed Variation Detection
  • Phonetic Variation Detection
  • Access Controls/Permissions
  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Database Conversion
  • Mobile Access
  • Multiple Programming Languages Supported
  • NOSQL
  • Performance Analysis
  • Relational
  • Virtualisation

WinSQL Most Helpful Reviews

Awesome Database Tool

Reviewed on 27/02/2019
Danny S.
President/CTO
Accounting, 2-10 Employees
Used the Software for: 2+ years
Reviewer Source 
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
Customer Support
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: 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.

WinSQL is a great tool for developing web tools

Reviewed on 27/02/2019
Nathaniel M.
Customer Program Analyst
Utilities, 1,001-5,000 Employees
Used the Software for: 2+ years
Reviewer Source 
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: 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.

Excellent, flexible SQL query tool

Reviewed on 28/02/2019
Shane D.
IT administrator
Financial Services, 13-50 Employees
Used the Software for: 2+ years
Reviewer Source 
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
Customer Support
4 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: 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

by Synametrics Technologies on 06/03/2019

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

WinSQL the way to pull your data

Reviewed on 28/02/2019
Chris V.
Sr. Industrial Engineer
Warehousing, 1,001-5,000 Employees
Used the Software for: 2+ years
Reviewer Source 
4/5
Overall
5 / 5
Ease of Use
3 / 5
Features & Functionality
Customer Support
5 / 5
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: Generally use it for adhoc data collection and the base to create user refresh able excel sheets.

Pros: I have medium level SQL skills. WinSQL is easy to use with no extra stuff. WinSQL never slows me down. I like the different tabs and the ability to keep the query on the session.

Cons: Hard to export large data sets (over 200k records)

Vendor Response

by Synametrics Technologies on 06/03/2019

Chris, WinSQL should be able to export over 200K records. Could you please contact our support so we can investigate why is it not letting you do that.

Queries with WinSQL

Reviewed on 27/02/2019
Leon B.
Industrial engineer
Semiconductors, 10,001+ Employees
Used the Software for: 2+ years
Reviewer Source 
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
Value for Money
Likelihood to Recommend:
Not Likely Extremely Likely

Comments: We have to constantly extract information form our DB2 databases. WinSQL is a fantastic tool to do so.

Pros: The lite version is very easy to install and easy to use and it's free!

Cons: With the new version, the software ask us frequently to reconnect. Secondly, maybe it's because I don't know how to do it but I'm not able to change the font size. I would also like to be able to remove the yellow area that pops up when you run a request.

Read More Reviews