You can use all the tools of dbForge Fusion for MySQL integrated into Visual Studio 2010.
Guided by a click-and-pick wizard, the users can easily import data from seven widely-popular formats (CSV, DBF, MS Access, MS Excel, ODBC, Text, XML) with a multitude of settings to meticulously tune the data. Microsoft Excel formats are supported as 2007, 2003 formats, and earlier.
Up to 40 improvements were implemented to create quicker, easier, and more delighted ways for data management. The Data Editor spares tens of mouse clicks a day for you saying nothing of tens of frowns.
The users can convert large amounts of data into compact and informative summaries - pivot tables. They can rearrange any obscure data by a simple drag of a mouse to get the layout best for understanding data relations and dependencies.
Every user can benefit from a modern way of generating reports. Less time and manual work is required, from getting required data from a database, analyzing, to printing it as a smart, clear, and stylish report tuned for each particular case.
Schema Export wizard has been totally redesigned to provide more freedom for backing up schemas. It features the following:
dbForge Fusion for MySQL offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.
Additional benefits:
Meet a stronger Query Builder tailored for creating complex conditions with several clicks. The new power is based on the following:
Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it embraces the following:
Besides physically existing foreign key relations, dbForge Fusion allows creating virtual relations. They help create relations between those tables which storage engine do not support foreign keys. Later virtual relations can be easily converted into physical foreign keys.
The users can easily select a required database within a current connection to execute SQL scripts and queries. There is no need to type USE statement to switch a database, and no database prefix is required to define what database to refer to. Also, an option to disable triggers, and the WHERE filter, that can be accessed from the Mapping page, were added to the Data Synchronization wizard. SQL Filter can be used to specify the expression to filter rows included into comparison.
Besides viewing the update information of dbForge Fusion, the users can customize the update process as they like.
Now, users can add hyperlinks to any files in database diagram notes.
Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template SQL scripts CREATE, DROP, SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in the context menu and called Create Script As.