MySQL Toolkit for Windows is a VSTS / TFS extension and contains helpful tasks for build and release definition for MySQL servers. You can run ad-hoc MySQL command, script or scripts collection on Windows Agents including Windows Hosted Agents (Linux Agents not supported).

NOTE

Connection to MySQL server based on Connection String. Certificate connection is not supported.

• Run MySQL command This task will run an ad-hoc query against your server or database.

• Run MySQL script This task will run a specified SQL script against your server or database.

• Run MySQL scripts This task will run all of the SQL scripts in the specified folder against your server or database.

NOTE

Each task can be executed on Server or Database level.

• If you want to use this extension on Private Windows Agents, see Windows System Pre-requisites and make sure .NET Framework 4.5 or newer is installed.
• Hosted Windows Agents meet system requirements for this extension, see Software on the hosted build server for reference.
• PowerShell 3.0
• Hosted or Private Agents must have network connection to MySQL servers

• Changed MySQL Client .NET library from 6.9.9 to 6.10.6.
• ISSUE #2 - Error running MySQL script: Exception calling "Fill" with "1" argument(s): "Index was outside the bounds of the array." Added AllowUserVariables=true; to Connection String by default.
• ISSUE #1 - Eliminate Write-Host usage - Changed Write-Host to Write-Output.
• Fixed typos in README file.

• Initial version on Visual Studio Marketplace.

Support for this extension is provided on GitHub Issue Tracker. You can submit a bug report, a feature request or participate in discussions.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

The extension is licensed under the MIT License (MIT), see license. Please see the third-party notices file for additional copyright notices and license terms applicable to portions of the software.