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