MySQL Forums
Forum List  »  MySQL Workbench

Migration on Workbench
Posted by: Kris Tidblom
Date: February 01, 2016 03:21PM

Yes, I can can connect to the MsSQL database and the target database in MySQL. However, when I get to the Schema page on Workbench it doesn't display anything so I cannot move onto the next screen.

How do I modify the MsSQL database to allow the use VIEW DEFINITIONS. Given the user isn't a SYSADMIN.

I found a video how to change the permissions on MsSQL but it won't let me change the permissions or even add a new user in the MsSQL Mgmt Studio.

VIDEO LINK:
http://mysqlworkbench.org/2013/08/video-tutorial-setup-a-restricted-sql-server-account-for-migrations-with-mysql-workbench/

Let me know if you need more information to clarify the issue.

Kris

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration on Workbench
1266
February 01, 2016 03:21PM
482
February 03, 2016 02:23AM
508
February 09, 2016 12:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.