dbForge Fusion for Visual Studio 2008 3.1

dbForge Fusion for Visual Studio 2008 3.1 is a simple to use, yet sophisticated add-in designed to simplify the MySQL database application development process.

It integrates into CodeGear Developer Studio, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.

1. Integration with the most popular IDEs
   • All database development and administration tasks available from your IDE
   • SQL Editor, database object editors and other editors behave like usual IDE documents
   • Help integrated into Microsoft Visual Studio .Net and CodeGear RAD Studio
   • 1 Integration with dotConnect for MySQL and MyDAC
   • Drag'n'drop objects onto form and dataset designers
   • Component editors extended with additional commands
2. MySQL Connectivity
   • Multiple database connections in Database Explorer window
   • Asynchronous connect to server with cancel feature
   • Support of all MySQL server versions 3.23-6.0
   • Direct access to MySQL server without client libraries
   • Support of UTF-8 databases
   • Support of SSL/SSH/HTTP connections
   • Work with MySQL embedded server
3. Schema Object Management
   • Visual editors for tables, columns, indexes, and views
   • Convenient editor for foreign keys
   • Partitioning support in a table editor
   • Visual editors for triggers, events, and user-defined functions
   • Combined editors for stored procedures and functions
   • Ability to browse schema objects in a single editor (pin document)
   • Duplicate object feature
   • Customizable DDL generation wizard
   • Schema object search based on a variety of parameters
   • Summary window for quick browsing of schema object properties
   • Data search on a live database
   • Multi-selection in Database Explorer for batch operations on schema objects
4. Advanced SQL Editing
   • SQL editor with syntax coloring, bookmarks, and text searching
   • Code outlining with support of user-defined collapsing regions
   • Navigation bar for jumping between object definitions within one document
   • Document Outline window for quick navigation on large scripts
   • Code templates library
   • Quick access to favorite templates from SQL editor
   • Context-sensitive code completion
   • Parameter information for stored routines
   • Quick information about schema objects
   • One step access to a schema object editor from code
   • Automatic SQL syntax check
   • SQL formatting on-the-fly in editor
   • Wizard for batch SQL formatting of files on disk
   • Dynamic help on MySQL accessible from the editor
5. SQL Execution and Data Management
   • Execution of scripts, selected SQL fragments, and statements
   • Execute Script Wizard for quick and convenient execution of large SQL scripts
   • Executed SQL history
   • Asynchronous execution with cancel feature
   • Execution plan tool
   • Transaction support
   • Data editor with in-place filtering, grouping, and sorting options
   • Paginal data access for large result sets
   • Graphical card view for data editor
   • Large objects (LOB) editor
   • Text search in data editor
   • Data printing
   • Ability to postpone sending of data updates to the server (Cached updates mode)
   • Data export wizard
   • Customizable data export to widely-used formats: CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML
6. Database Designer
   
   • Visualization of tables, views, and stored routines
   • Easy access to database objects to view and edit their properties, retrieve data, execute stored routines, etc
   • Support for IDEF1X and IE notations
   • Customizable diagram look and feel with skin support
   • Smart diagram layout
   • Diagram export to different image formats
   • Searching database objects on diagram
   • Organizing diagram shapes with containers
   • Customizable diagram printing with a rich set of options
   • Optional displaying of table constraints, indexes, and triggers
   • Integration with Document Outline window
   • Diagram navigation with Diagram Overview window
   • Notes for adding your comments to the diagram
7. Visual Query Builder
   • The state-of-art diagram with zooming and keyboard support
   • Preview and printing of the diagram
   • Query outline (displayed in Document Outline window)
   • Visual editing of sub-queries
   • Copy/Paste for tables on a diagram
   • Expression builder for creating complex conditions
   • Undo/Redo support
   • Saving queries to a file
8. Stored Routine and Script Debugging
   • Support of procedures, functions, and triggers
   • Single-click debug engine deployment
   • Step-by-step execution
   • Breakpoint management
   • Call stack navigation
   • Watches window for variable evaluation
   • Evaluation of variables when debugging a script
9. Server Administration and Maintenance
   
   • Security Manager to administer user accounts and privileges
   • Quick access to object privileges from Database Explorer
   • Schema export and import wizards
   • Table maintenance wizard for check, analysis, repair, and 1 optimization of tables
   • Server objects flush dialog
   • Session manager
   • Service control for starting and stopping MySQL servers
   • Server Variables window
10. Schema Comparison and Synchronization
    • Ability to compare a database with a database
    • Ability to compare a database with a project
    • Synchronization between different server versions
    • Comparison results filtering
    • Schema synchronization script generation
    • Per object viewing of DDL differences
    • Objects exclusion from synchronization
    • Save and load comparison settings
11. Data Comparison and Synchronization
    • Comparison of large tables
    • Optional view comparison
    • Custom comparison keys support
    • Option for BLOB data comparison
    • Filtering of comparison results
    • Schema synchronization script generation
    • Per record viewing of data differences
    • Exclude tables and records from synchronization
    • Save and load comparison settings
12. Database Project
    • New project wizard with import from an existing database
    • Project Explorer window for managing project files
    • Object View window for browsing logical project structure
    • Export of project files into one script
    • Reference checking while building
    • Multiple build configurations
    • Single-click project deployment on the server
    • Database object refactoring
    • Schema comparison tool integration
    • Workspace saving
13. Customizable User Interface
    • Rich user settings
    • Customizable window layout
    • Tool windows with 'auto-hide' and 'float' modes
    • Multiple shortcut schemes with full shortcut customization
    • Syntax highlight customization
    • Tabbed groups for documents
    • Toolbars customization
    • Ability to browse schema objects in a single editor (pin document option)
    • Wizard for exporting/importing user settings

Enhancements:

• Support of multiple database project deployment connections
• • Now you can set different connections for project configurations. These connections allow you to deploy the same database project to various servers. You get more freedom in handling the project. For example, you can test the project on one server and deploy the final version to another one.
• Incremental database project synchronization with the server
• • Now when you apply the project changes to the server, you can deploy only the required ones and be sure that no data on the server will be lost as during the usual deployment. This feature is a good contribution to database development.
• Database object dependencies supported
• • In prior versions the Generate DDL, Schema Export, New Project Wizard, Schema Synchronization wizards generated SQL scripts paying no attention to object dependencies. Now all objects in SQL scripts are generated based on object dependency sorting principle. For example, if View 1 refers to View 2, View 1 will come first or tables will follow those tables which refer to them.
  • This ensures that the generated SQL scripts will be executed without errors and you won't loose your time for additional code editing.
• Optimized SQL editor performance
• • SQL editor performance has been greatly increased due to optimized parsing of SQL scripts. You can open and edit large SQL scripts quicker. Moreover, to speed up your work, automatic switching off SQL editing features in large SQL scripts is implemented.
• Filter toolbar in Error List window
• • Filter toolbar is added to Error List window to show the quantity of errors, warnings, and messages. Also it filters the list of records, so that you can access the records of the selected type in one click.
• Sample database project added to the installation
• • Learning the structure and peculiarities of database projects has become easier. A sample database project, based on MySQL database Sakila, is added to the installation. Using the sample, even beginners will quickly get the idea and start working with projects successfully.