WinSQL

WinSQL

by Synametrics Technologies

Who Uses WinSQL?

Bank, Insurance, Healthcare

What Is 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 Details

Synametrics Technologies

http://www.synametrics.com

Founded 2002

WinSQL Pricing Overview

WinSQL has a free version and offers a free trial. WinSQL paid version starts at US$99.00.

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

WinSQL Features

Data Analysis Software
Dashboard
Data Discovery
Data Source Connectors
Data Visualisation
Natural Language Search
Predictive Analytics
Query Builder
Reporting/Analytics
Self Service Data Preparation
Self-service Analytics
Storytelling
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 Reviews for UK Users

Showing 5 of 29 reviews

Overall
4.4/5
Ease of Use
4.6/5
Customer Service
4.3/5
Features
4.2/5
Value for Money
4.7/5
Deepak M.
Senior Engineer - Product Development
Information Technology & Services, 10,001+ Employees
Used the Software for: 1-5 months
  • Overall Rating
    5/5
  • Ease of Use
    5/5
  • Features & Functionality
    4/5
  • Customer Support
    5/5
  • Value for Money
    5/5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 29/02/2020

"Handy and light weight database administration tool"

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

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

"Awesome Database Tool"

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.

  • Reviewer Source 
  • Reviewed on 27/02/2019
John G.
Database Management Team Leader
Broadcast Media, 10,001+ Employees
Used the Software for: 2+ years
  • Overall Rating
    1/5
  • Ease of Use
    5/5
  • Features & Functionality
    3/5
  • Customer Support
    3/5
  • Value for Money
    3/5
  • Likelihood to Recommend
    0/10
  • Reviewer Source 
  • Reviewed on 28/02/2019

"WinSQL is now banned on SAP IQ"

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

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

"WinSQL is a great tool for developing web tools"

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.

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

"Excellent, flexible SQL query tool"

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.

  • Reviewer Source 
  • Reviewed on 28/02/2019