11.1 Prerequisites

  • Download the latest MySQL Connector/ODBC driver to the Microsoft SQL server. You can get this driver from the MySQL development website.

    This driver enables you to establish a connection between the MySQL server and the Microsoft SQL server.

  • Download and install the Microsoft SQL Server Migration Assistant for MySQL onto the Microsoft SQL server, as described in the Microsoft Developer Network.

  • Modify an existing user on the MySQL Appliance so that the user is associated with the IP address or DNS name of the Microsoft SQL server where the Microsoft SQL Server Migration Assistant for MySQL is installed. This can be accomplished via phpMyAdmin or the MySQL appliance.

  • Stop the Filr service on any Filr appliances in the Filr system, as described in Managing System Services in the Filr 3.4.1: Administrative UI Reference.