MySQL Forums :: MySQL Workbench :: migration mssql to mysql


Advanced Search

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 116 Ricky Stambach 04/03/2017 01:44PM
Re: migration mssql to mysql 47 Milosz Bodzek 04/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.