Features/Benefits

Rich SQL programming IDE

Highly productive environment with code generation, multiple query pages and customizable editor
Comprehensive scripting support including syntax highlighting, auto-code complete, and built-in hot keys
Visual tools for ad-hoc data editing and simple to complex query building
Enhanced wizards for creating tables, indexes and other objects
WYSIWYG SQL wizards - helps novice users in learning WinSQL

Perfect tool for data migration

Migrate data from any database to another database. For example, from Oracle to DB2 or the other way around. Use drag-n-drop to move data from one source to another
Export to text files
Import from text files - drag and drop files from Windows Explorer. More info...
Integration with MS Excel - drag and drop Excel sheets in WinSQL or open a resultset in MS Excel
Generate INSERT INTO statements for existing data
Import/export either manually or schedule a task that runs periodically
Generate an EXE file based on a SQL query. Generated executables are royalty free and can run on any machine with or without WinSQL. More info...

Generate Executables

Generate an EXE file based on a SQL query. Generated executables are royalty free and can run on any machine with or without WinSQL. More info...
Ideal when distributing to business users who are not familiar with SQL scripts.
Can prompt for parameters at runtime, which changes the WHERE clause resulting in filtered results.

Enhanced data and schema comparison

Compare schema differences between two databases
Compare data differences between two similar tables - either in the same database or a different database
Works across multiple RDBMS

Excellent test data generation tool

Generate millions of rows for testing purposes
Read data from several sources, such as text file, other tables or using pre-defined formats

Designing tools

Easily draw E/R diagrams and view relationships among tables with just a mouse click
Pull scripts for views, triggers and stored procedure
Easily search objects in the database by specifying a search string
Efficiently navigate through the database catalog

Navigation

Social Media

Powered by 10MinutesWeb.com