Full version (For new users ~ 17.1 MB) Upgrade (For existing users ~ 1.9 MB)
Task Scheduler
Create scheduled task for
Run SQL scripts
Exporting data to other database or HTML
Running Data Diff and Schema Diff wizards
Once a task is completed, you can configure WinSQL to send email messages with status report.
What can you do with scheduled tasks?
Well, pretty much anything you can do with SQL scripts such as:
Backing up databases
Inserting and updating records
Updating database statistics
And much more...
Data Lookup
Besides table names and field names, now the Intelli-Tip can pull data when writing SQL queries. By default,
this data lookup feature only pulls first 100 records from the table. This value is configurable.
Database object search
Search for a desired string across different objects within a database. Depending upon the
database you are connected to, search can be performed on several different type of objects, such as:
Tables
Indexes
Views
Stored Procedures
Triggers
Virtual Grid
Prior to version 5.5 the all fetched results in WinSQL where being stored in memory. Making it restrictive
as far as the number of records that could be displayed. Version 5.5 uses Virtual Grids - meaning only
visible records stay in memory. This feature allows WinSQL to display millions of record in the result
grid without any affect on memory.
Enhanced Grid Export to CSV and Tab delimited files
A newly designed Grid Export routines to CSV and TAB files makes the export much faster.
Enhanced User Interface
Most prominent difference in version 5.5 is the interface. Many subtle changes have been made to make the user's
experience friendlier than ever before. Some of these changes are: