HowTo: MySQL new toolbar inside the Visual Studio IDE
By Gab Martinez-Oracle on Mar 11, 2014
MySQL for Visual Studio 1.1.4 was released including a new feature: MySQL Toolbar inside the Visual Studio environment. This post will cover the details on this new feature.
- Visual Studio professional Edition 2008, 2010, 2012 or 2013.
- MySQL for Visual Studio 1.1.4 download link
- A running instance of MySQL Server 5.0 - 5-6 version download link
After installing MySQL for Visual Studio, the MySQL toolbar is available by selecting the Menu View -> Toolbars -> MySQL. After the toolbar is selected all the following times that Visual Studio opens this Toolbar will be visible along with the rest of the toolbars selected in the toolbars menu.
The following image shows the MySQL toolbar:
The commands available at this new toolbar are the following:
- MySQL Script window: Opens a new MySQL Script window using the selected connection. All available MySQL connections are listed in a submenu that is showed when this version is selected. The MySQL Script window has a MySQL intellisense features to ease the MySQL script creation inside Visual Studio.
- Debug MySQL routine: Starts a debugging session on the selected MySQL stored routine inside Visual Studio.
- MySQL Data Export tool: Opens a new tabbed-window of the Data Export tool. A quick tutorial on using this feature can be seen here.
- Open MySQL Workbench SQL Editor : Opens a new Workbench with a SQL editor window using the current MySQL connection if Workbench is installed. (Download link)
- Open MySQL Utilities console: Opens a new Console window for the MySQL Utilities tool. Only if MySQL Utilities is installed. This tool can be downloaded here
The MySQL toolbar adds some shortcuts to some of the main options included at the MySQL for Visual Studio product. This feature is included within the 1.1.4 or further versions.
We look forward to hear your feedback and comments.
Join the discussion by using this blog or at the MySQL for Visual Studio forum.
Hope you find this information useful.
Happy MySQL/Net coding!