WinSQL

WinSQL

 

A homogeneous solution for heterogeneous environment

A universal database tool that works with almost every database available in the market today.

 

What can it do for you?

 

Universal Connectivity

Connect to a variety of databases, including: heavy duty vendors Oracle, MS SQL Server, DB2, Sybase, Informix to lightweight back ends like MS Access, DBase, and Text File.

 

Dynamic Executables

Generate royalty-free executables that can be used by your business users to run queries. These can be either static or dynamic queries that pull fresh data from the back-end.

 

Works with MS Excel

Export or simply open any query results into MS Excel with just a click of your mouse. You can even import an existing Excel spreadsheet to a database table by simply dragging an *.XSL file in the catalog tree.

 

Data Migration

Import data from any database and export it to another back-end with a simple drag-n-drop.

 

Schema and Data Diff

Generate schema and data diff reports between two similar back-ends, such as your development and production DB.

 

E/R Diagram

Easily visualize your database design by either letting WinSQL draw the diagram or you create it manually.

 

A homogeneous solution for heterogeneous environment

It's like a Swiss-Army knife for database development.

• Connect to almost any RDBMS
• Run queries to view and modify data
• Import/Export Data with drag-n-drop
• Visualize design with E/R Diagrams
• Integrate with MS Excel
• Generate royalty free executables
• Generate test data
• Scheduled tasks
• Compare schema and data differences
• SQL Wizards to generate queries with mouse clicks
• Maintain historic data and auto-save sessions
• and a lot more...

 

Comparing WinSQL Lite, Standard and Professional

 

Note: The Standard edition was formerly known as Developer edition.

 

Features	Lite	Standard	Pro.
Syntax highlighting for SQL script
New table wizard
HTML publishing wizard Export the result of a query to linked HTML pages.
Database catalog - Display tables, views, stored procedures and other database objects
Run selective query - Highlight part of the script and send just that to the server
Display results in grid, text or form
Support for database transactions
Customized editor
Local comment parsing
Parameterized queries
Submit batches Queries can be separated by a separator and therefore, multiple queries can be submitted at the same time.
Multi-threaded architecture
CREATE TABLE statement wizard
Data browsing
Update/Insert record wizard
ODBC Drivers for Oracle, DB2, MS SQL Server, Informix, Sybase, Pervasive, Text, XML, dBase, FoxPro, Paradox
Inline results
Result printing
Integrated View
Relationship manager
Local relationships
Drill down results
Integration with Microsoft Excel
Scripting wizard
Query History
Associate comments with database objects
SQL Explain
Administrative Tasks
DDL wizard
Command line support
SQL wizard
Editable result sets
Extended support for binary and long data (BLOB/CLOB)
Intelli tip
Data Lookup
Import/Export data with drag-n-drop capabilities
Grid result export
Save results to an executable file
INSERT statement wizard
Test data generation wizard
Task Scheduler
Database Search
Entity Relationship Diagrams
Database specific plugins
Browse data filter
Schema Diff
Data Diff
Offline Backup/Restore
Stored Procedure Wizard
QuickMath
Catalog printing
List of available datatypes

 

WinSQL 15 Available on November 17, 2020

 

Synametrics Technologies, Inc. is proud to announce the release of WinSQL 15.

New Features

• ODBC drivers are now available for both 32 as well as 64 bit WinSQL.
• New 64bit drivers are now available for:
  • Amazon Redshift
  • Apache Cassandra
  • Apache Hive
  • Apache Spark
  • Google BigQuery
  • MongoDB
  • Salesforce
  • Snowflake
• Ability to Export entire database to CSV or Pipe delimited format
• Ability to schedule exports to CSV or Pipe delimited