dbForge Fusion for MySQL, Visual Studio Add-in 3.10

dbForge Fusion for MySQL, Visual Studio Add-in 3.10( MyDeveloper Tools) offers an useful software which helps you to simplify the MySQL database application development process. It integrates into Visual 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.

Major Benefits:

1. Smooth integration into MS Visual Studio and CodeGear RAD Studio
   • Have more essential tools at your fingertips while using CodeGear RAD Studio or MS Visual Studio.
   • All database development and administration will become clearer and quicker.
2. Offline Development with Database Projects
   • Enhance your work with complex database projects.
   • Instead of doing lots of time-consuming tasks, perfect your management with well-tried features. You can integrate various SQL and script files into a project, group them into folders, and manage in one place. Export your project to a single script file or several ones and easily deploy it on the server. Feel difference
3. Stored Routine Debugger
   • Replace “by hand” debugging with the full-featured Debugger tool.
   • Debug stored procedures, functions, and triggers with no worry. You can easily set breakpoints to stop execution on any code line and evaluate variables and parameters declared in routines. Find other features for best result.
4. Schema and Data Comparison and Synchronization Tools
   • Experience new opportunities for precise comparison and synchronization. Forget about difficulties, just select two databases (or a database and a project) to compare.
   • Based on your needs, you can compare and synchronize the structures of databases (schema comparison) or the content of databases (data comparison). Manage differences in a convenient window and simply select the required synchronization actions.
5. Powerful SQL Management
   •  Well-thought features will save your time while coding and free you from tedious work.
   • Speed up your development with code templates, code completion, syntax check, Code formatter, and many other options. Make your work simple and pleasant.
6. Visual Query Builder
   • Create effortlessly complex queries which you could not create before.
   • Do not think about coding, just use Query Builder. Drag’n’drop required tables to the diagram, select parameters, set conditions in a convenient editor, and then view and edit a query text.
7. .Convenient Schema Object Editors
   • Convenient Schema Object Editors
   • Manage efficiently schema objects in visual editors.
   • Get clear and automated ways to work with tables, views, procedures, functions, triggers, events, and user-defined functions (UDF). Take advantage of quick search and navigation.
8. .Centralized Server Administration and Maintenance
   • Centralized Server Administration and Maintenance
   • Have centralized server maintenance with powerful tools.
   • Use Security Manager to have simple and accurate management of users and their privileges. Get total control of user sessions and their information with Session Manager. Benefit from MySQL services empowered with Service Control window. Transform difficult tasks into your new opportunities.
9. Multiformat Data Export
   • Multiformat Data Export
   • Experience visual and accurate data export to well-known formats.
   • You will quickly choose required columns and rows along with additional settings for the selected format. With Data export wizard you can customize and even preview the result. You won’t waste your time changing the exported data, the result will be just what you wanted.
     

Major Advantages:

• Integration with the most popular IDEs
• Integration with MyDirect .NET and MyDAC
• Project management framework
• Advanced stored routine debugger
• Powerful schema and data comparison tools
• Context-sensitive code completion
• Quick code navigation
• Automatic SQL syntax check
• Customizable SQL formatting
• Handy schema object editors
• Visual Query Builder
• Integrated Security Manager
• Server maintenance toolkit
• Schema export and import wizards
• SQL template library
• Schema object search engine
• Multiformat data export
• Full support of MySQL versions 3.23-6.0
• Direct access to a server
  

dbForge Fusion for MySQL brings MySQL development and administration power to the newest development environments from Microsoft:

• Visual Studio 2008
• Visual Studio 2005

Major Features:

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 Borland Delphi
   • 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, foreign keys, and views
   • Partitioning support for 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 searching 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 (go to definition)
   • 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
   • 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
   • Data export wizard
6. Visual Query Builder
   • State-of-art diagram with zooming and keyboard support
   • 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
   • 1Stored 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
   • Evaluate session variables when debugging a script
7. 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
   • Server objects flush dialog
   • Session manager
   • Service control for starting and stopping MySQL servers
   • Server Variables window
8. Schema Comparison and Synchronization
   • Compare a database with a database
   • Compare a database with a project
   • Synchronization between different server versions
   • Comparison results filtering
   • Schema synchronization script generation
   • Per object viewing of DDL differences
   • Exclude objects from synchronization
   • Save and load comparison settings
9. 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
10. 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 project files into one script
    • Reference checking on build
    • Multiple build configurations
    • Single-click project deployment on server
    • Database object refactoring
    • Schema comparison tool integration
    • Workspace saving
11. 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
    • Tool bars customization
    • Wizards for exporting/importing user settings