DreamCoder for MySQL Enterprise 4.7

Easy management of all MySQL objects

• Creating/Dropping databases
• Creating/Alter/Dropping tables
• Creating/Dropping Stored Procedures ( MySQL Server 5.0)
• Creating/Alter/Dropping/Viewing/Editing data in Tables ( MySQL Server 5.0)
• Creating/Alter/Dropping Triggers ( MySQL Server 5.0)
• Creating/Alter/Dropping Schedule Events ( MySQL Server 5.1)
• Creating/Editing/Dropping index.
• Support of all MySQL TABLE types (including transaction-safe-tables)
• Creating/Editing/Dropping users
• Creating/Editing/Dropping foreing keys
• Support of all field types (including BLOBs)
  

SQL processing and watching tools

• Multiple SQL Editors
• Parameter Manager.
• Script Executing (SQL Script Editor)
• SQL Monitor
• Templates Options
• Powerful Print Metadata Module for creating customizable metadata reports
• Extracting metadata INTO text files or SQL Script editor
• Powerful User Manager for administering users and privileges
  

Powerful data manipulation tools

• Powerful BLOB Viewer/Editor with several types of viewing BLOB data
• Export data in to 14 popular formats like MS Access, MS Excel, MS Word , HTML.
• Import data from in 7 popular formats like MS Excel, MS Access, XML, TXT and CSV.
• Export data to SQL script as INSERT statement
• Advanced Grid Options. ( Copy and Paste records for Ms Excel)
• Grid Fileters.
• Grid Group, Sort and Summarize information.

Fully customizable program interface

• Program options: windows, fonts, grid colors, etc.
• Editors: custom colors, fonts etc.
• Toolbars for all program windows
• Powerful Visual Options Module
• Possibility of saving all the program settings
• Localizable program interface

Major Features:

1. SSH Tunnel connection
2. Characterset Encodings (UTF8, GB2312, BIG5, Hebrew, Greek, etc.)
3. SSL connection
4. Administration of project
5. MDI Interface - Microsoft Office Style
6. User Manager
7. Report Designer - build powerful reports visually
8. HTML Report Generator
9. Master Detail Table Browser
10. Database Reports
11. SQL Formatter
12. Database Data Synchronization
13. Database Structure Synchronization
14. Advanced Query Builder
15. Object Description
16. List Value for foreing keys
17. SQL History
18. Powerful PHP code editor
19. Powerful HTML code editor
20. Powerful Java code editor
21. Powerful XML code editor
22. PHP Highlighter
23. Java Highlighter
24. HTML Highlighter
25. XML Highlighter
26. Procedure Evaluator
27. UDF Manager
28. BLob Viewer
29. Database Transfer
30. Clone Object
31. Export Manager
32. Connection manager
33. Graphical TABLE status
34. Graphical databases status
35. Generate Table SQL
36. SQL Autocomplete
37. Constraint Manager
38. Index Manager
39. Graphical Session Monitor
40. Foreign key support for InnoDB tables
    

Requirements

• DreamCoder for MySQL will run on Windows 95, 98, NT4, 2000, 2003, XP and Vista.
• The supported MySQL Server versions are 3.23, 4.0, 4.1, 5.0, 5.1 and 6.0 or higher on any platform.
• To connect to an MySQL database, DreamCoder for MySQL only requires TCP/IP.