What’s new in ApexSQL: ApexSQL Search for MySQL – MySQL search free add-in for Visual Studio

We are proud to announce the first add-in for MySQL from the ApexSQL family: ApexSQL Search for MySQL. This is a free MySQL search add-in that can be integrated into Visual Studio.

This add-in supports integration into Visual Studio 2015 and higher:

MySQL search host integration step in the Wizard

With ApexSQL Search for MySQL, a MySQL object from MySQL Server 5.6 and higher can be searched. The add-in supports searching objects on MySQL database that are located on the cloud (Azure Databases for MySQL, Amazon RDS for MySQL).

To initiate MySQL search feature, from the Server Explorer pane, select a MySQL database, right-click on it, and from the context menu, choose the Object search command as shown below:

MySQL search context menu in Server Explorer

Also, this command is available from ApexSQL Search for MySQL main menu (Extensions menu in VS), as well as from ApexSQL Search for MySQL toolbar:

MySQL search toolbar in Visual Studio

In the Search text box, enter the string that you want to search for, over selected MySQL database and click the Find button:

MySQL Search text box

All results for the set criteria will be shown in the search result grid:

MySQL search result grid

To narrow the search scope, adjust options by specifying whether to match (e.g. Object names, Object bodies, Exact match) to the searched text:

MySQL search options

Similarly, it can be set which object types will be searched, by selecting the object of interest in the Object types drop-down box:

MySQL object types

Additionally, found objects from the object search result grid can be easily located in the Server Explorer pane. To do this, select an object in the result grid, right-click on it, and from the context menu, choose the Navigate to server explorer node command:

Navigate to server explorer node command

All search results can be copied to clipboard or saved in some of the available formats (HTML, XML, CSV):

Export options for MySQL search result

 

January 9, 2020