Video Tutorial: Setup a Restricted SQL Server Account for Migrations with MySQL Workbench

August 6, 2013 – 5:11 pm by Milosz Bodzek

Some users have asked us what is the minimum set of privileges that your Microsoft SQL Server user needs to successfully migrate databases from SQL Server using the MySQL Workbench Migration Wizard. Even though we don’t execute any query that alters anything in your source RDBMS servers, it’s never a bad idea to add an extra security barrier around it.

In short, you need the VIEW ANY DEFINITION permission for the server and the CONNECT andSELECT permissions for the database(s) you want to migrate. But to make this easier for you, we have created a video tutorial showing how to create a user with these permissions using the Microsoft SQL Server Management Studio.

Sergio de la Cruz

Milosz Bodzek

Post a Comment


7 + = ten