MS SQL Server to MySQL

[Carsten Haefeker]

Hi,

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

dbo
INFORMATION_SCHEMA
system_function_schema

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

dbo

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.