|
|
|
|
|
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
- Export to text files
- Import from text files
- Generate INSERT INTO statements for existing data
- Import/export either manually or schedule a task that runs periodically
- Use drag-n-drop to move data from one source to another
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
Visual tools
- Easily draw E/R digrams 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 specifiying a search string
- Efficiently navigate through the database catalog
|
|
|
|
|