MS SQL Server to MySQL
Posted by: Carsten Haefeker
Date: June 08, 2005 10:33AM


I'm connecting to MS SQL Server using the Migration Tool. Connection is fine, but it only shows me 3 options:


this was because the user I used for the connection had the "master" database associated to it as standard database. After changing it to the database I want to migrate I only see


as schema to choose. This does not get me to the tables of the real database.

Should I try the migration by starting with dbo? I don't think so.

What am I doing wrong?

I found the problem. The user I used for the SQL Server did not have sufficient rights. I changed this, started the migration using dbo and it now runs perfectly.

Thanks for all the replies and help :-)

Edited 2 time(s). Last edit at 06/10/2005 08:06AM by Carsten Haefeker.

Options: ReplyQuote

Written By
MS SQL Server to MySQL
June 08, 2005 10:33AM

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.