MySQL Forums
Forum List  »  MySQL Workbench

migration mssql to mysql
Posted by: Ricky Stambach
Date: April 03, 2017 01:44PM

I'm trying to migrate from mssql to MySQL using workbench and I'm following the instructions at http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/
When I leave the Source Selection Database blank I do not have any Schemas to select from in the Schemas Selection. If I enter a database name I get the following error message;
WARNING: The following catalogs were not found:
I found this video instruction on setting up a account for migration;
http://mysqlworkbench.org/2013/08/video-tutorial-setup-a-restricted-sql-server-account-for-migrations-with-mysql-workbench/
My ms sqlsms does not work the same as the video, I have SQL Server 2016 Management Studio version 13.0.16.106.4. It doesn't have the dialog box to create a new login. I only get a sql query;
-- ======================================================================================
-- Create SQL Login template for Azure SQL Database and Azure SQL Data Warehouse Database
-- ======================================================================================

CREATE LOGIN <SQL_login_name, sysname, login_name>
WITH PASSWORD = '<password, sysname, Change_Password>'
GO

Thanks for any help

Options: ReplyQuote


Subject
Views
Written By
Posted
migration mssql to mysql
205
April 03, 2017 01:44PM
83
April 07, 2017 03:23AM


Sorry, only registered users may post in this forum.

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.