Note: Once at the shopping cart web page, please fill the number into the quantity blank to purchase this product. (1 is default)
Click "Get It Now" Button above or below to activate this coupon code or deal. It's only valid on SoftCns.com If The Coupon Code Not Available Please bookmark this page first, and then clear the cookies of your browser. Lastly, restart your browser again or try to use another web browser, If you don't get it clearly, please visit Coupon Using Guide or send us expired.
dbForge Studio is a powerful and comprehensive MySQL GUI tool that provides a complete set of instruments for server management and administration. It offers tools for database development, administration tools, and SQL query tools. Combination of the very best features of existing MySQL front ends and MySQL GUI tools makes dbForge Studio the perfect choice for a database developer and administrator as well as for a novice user.
With dbForge Studio MySQL GUI, you can manage MySQL databases in a relaxed way. It can save you hours and hours of boring manual work. Have you ever been stuck somewhere in database management or administration? Are you a newbie to MySQL server and want to learn how to perform simple tasks? MySQL GUI tools provided by dbForge Studio are here to solve your problems.
Why dbForge Studio is the very MySQL GUI tool for you? dbForge Studio is a MySQL GUI client that can be used by a wide range of MySQL server users, because advanced features required by database developers and administrators go together with more commonly used functionality and are available as a set of easy-to-use tools.
If you are:
Developer You will surely appreciate the possibility of working with a remote MySQL server owned by your Internet service provider. HTTP tunnel allows a PHP developer to connect even to a server that does not have direct access. Besides the fact that your work on the localhost will be comfortable, you will be able to apply changes in schema and data to your site.
Administrator A complete tool kit for tuning, monitoring, and keeping MySQL server in a fully functional state is at your fingertips. You will be able to adjust server security settings, make backup copies, migrate data, and perform a wide range of other tasks.
Data Analyst You will be able to create queries of any complexity to retrieve data for further analysis, export, or report creation. Excellent tools for creating SQL queries, data reports, and pivot tables will be there for you.
Novice User If you cannot call yourself a professional, and you've just started to use MySQL server, our MySQL GUI tool will be a good help for you. Powerful functionality is available via intuitive interface that will help you make fast progress in your work.
Administration and Maintenance • Comprehensive Security Manager to administer user accounts and privileges • Session manager for monitoring active MySQL server connections • Service control for starting and stopping MySQL servers • Table maintenance wizard for check, analysis, repair, and optimization of tables • Server Variables window • Server objects flush dialog
Backup • Comprehensive MySQL backup and restore wizards • Schema or data only backups in addition to full backups • Large database (exceeding 2 Gb) support • Backup projects to save settings for future use • Zip compression for backup files • Command line support for scheduling backup tasks • Error and status logging
Data Analysis • Master-detail data browser • Data report generation wizard • Data report designer • Pivot table designer • Chart building wizard • Data search on a live database
Data Comparison • Comparing and synchronizing data in databases of any size • Optional view comparison • Custom comparison keys support • Option for BLOB data comparison • Comparison results filtering • Data synchronization script generation • Per record viewing of data differences • Exclude tables and records from synchronization • Saving and loading of comparison settings • Command line interface for data comparison and synchronization • Generating accurate comparison reports in HTML and Excel formats
Data Editor • Asynchronous data fetch with ability to cancel the operation • Batch table update mode when changes are accumulated and applied explicitly • Copying data with column headers for quick paste to spreadsheet • Custom data filters of any complexity • Data Viewer window for browsing images, rtf, and binary cell values • Date time editor with visual interface • Foreign key lookup editor for easy editing of fields referencing other tables • Free copying of any block of data to clipboard • Full-text search (Ctrl+F) through data grid • Graphical card view • Grouping by arbitrary columns • Incremental search (Ctrl+I) through data grid • Large objects (LOB) editor • Multi-table query result set editing • Paginal data browsing for large result sets • Printing of data • Quick filter feature available for each data cell • Record numbering option • Read-only state indication • Report, chart, and pivot building directly from data editor • Server-side sorting and filtering to help dealing with large data sets • Visible columns picking dialog box
Database Explorer • Multiple database connections allowed • Asynchronous connect to server with ability to cancel the operation • Detailed object properties and data browsing in Object Viewer window • Dependency tree browsing for each object • Duplicate object feature • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc • Customizable DDL generation via wizard • 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools • Smart column renaming that allows rebuilding dependent tables • Quick access to object privileges (GRANT) from the popup menu • Multi-selection for batch operations on objects • Database navigation history
Debugger • Stored procedure and function debugging • Trigger debugging • Script debugging • Step Into, Step Over, and Step Out commands for step-by-step execution • Breakpoints support for procedures, functions, triggers, and scripts • Breakpoints window • Call Stack window with navigation • Watches window for variable evaluation • Evaluation of session variables when debugging a script • Single-click debug engine deployment
Exporting and Importing Data • Data export to: - CSV - XML - Text - XLS - PDF - DBF - HTML - RTF - MDB (Access) - ODBC • Export data from multiple tables at once • Export data from command line interface • Data import from: - CSV - XML - Text - XLS - XLSX - DBF - MDB (Access) - ODBC • Import data from command line interface • Templates for exporting and importing
MySQL Connectivity • Support of all MySQL server versions 3.23-5.5 • Secure connections via SSL/SSH • HTTP connections via PHP tunnel • Support of UTF-8 databases • Work with MySQL embedded server • Direct access to MySQL server without client libraries
Object Editors • 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) • Schema object search based on a variety of parameters
Projects • New project wizard with import from an existing database • Project Explorer window for managing project files • Schema View window for browsing logical project structure • Project export into one script • Reference checking while building • Multiple build configurations • Single-click project deployment on the server • Code refactoring • Schema comparison tool integration • Workspace saving
Query Builder • The state-of-art diagram with zooming and keyboard support • Preview and printing of the diagram • Visual addition of sub-queries to any part of the main query • Query outline (displayed in Document Outline window) • Visual editing of sub-queries • Expression builder for creating complex conditions • Copy/Paste for tables on the diagram • Undo/Redo support • Saving queries to a file
Query Profiler • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI • Plan of the query displayed in the tree view for easy review • Profiling history that can be saved for further analysis • Compare profiling results feature with differences highlight • Profiling results printing
Schema Comparison • Capability to compare a database with a database • Capability to compare a database with a project • Schema comparison reports generation • Command line launch for schema comparison and synchronization • Synchronization between different server versions • Comparison results filtering • Schema synchronization script generation • Per object viewing of DDL differences • Objects exclusion from synchronization • Saving and loading comparison settings
SQL Editing and Execution • Automatic SQL syntax check • Code outlining with support of user-defined collapsing regions • Code templates library with a browser window • Context-sensitive code completion • Context-sensitive dynamic MySQL help accessible from the editor • Document Outline window for quick navigation through large scripts • Execution of scripts, selected SQL fragments, and statements • One step access to a schema object editor from code (go to definition) • Parameter information for stored routines • Quick access to favorite templates from SQL editor • Quick information about schema objects • SQL editor with syntax coloring, bookmarks, and text searching • SQL formatting on-the-fly in the editor • Executed SQL history window for the document • Wizard for batch SQL formatting of files on the disk
Visual Database Designer • Visualization of tables, views, and stored routines • Easy access to database objects for viewing their properties, editing, retrieving data, • executing 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
User Interface • Start page providing easy access to main product features • Rich user settings • UI skins • 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
Requirements • .NET Framework 2.0, 3.0, 3.5, or 4.0 installed • You can download .NET Framework 2.0 and its Service Pack here. • Note, .NET Framework is pre-installed in Microsoft Windows Vista and Windows 7. • 2 GHz or higher processor • 1024 MB RAM • 35 MB of free hard disk space • Microsoft Windows 2000/XP/2003/Vista and Windows 7