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

August 6, 2013 – 5:11 pm by Sergio de la Cruz

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 and SELECT 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

  1. 3 Responses to “Video Tutorial: Setup a Restricted SQL Server Account for Migrations with MySQL Workbench”

  2. Hi,

    We cannot get the “View Any Definition” permission since we are on a shared server.

    Is there an option to give this access to a specific database only?

    If so, how is that done?

    Thanks for your help!

    Chrony

    By chrony on Oct 21, 2013

  3. nice article.it,s really help me.thanks for this post.

    By neelam ojha on Oct 28, 2013

  4. Giving that access to the specific DB you need to migrate should be enough. But you’ll probably get better help about how to get that done with SQL Server people.

    By akojima on Nov 7, 2013

Post a Comment


2 × = fourteen