MySQL Forums
Forum List  »  Microsoft SQL Server

MSSQL2008 -> MySQL via migration wizard - space in database name
Posted by: patrick king
Date: March 28, 2013 10:23AM

Trying to migrate an existing MsSQL2008 to MySQL 5.5
I am able to connect to both servers.

I get to the 'Reverse Engineer Source', and get an error message.

Here is the important part of the error message:

Reverse engineer selected schemata....
Reverse engineering dbo from Project Connect
- Reverse engineering catalog information
- Reverse engineering User Data Types...
- Preparing...


pyodbc.Error: ('08004', "[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'Project' does not exist. Make sure that the name is entered correctly. (911) (SQLExecDirectW)")


As you can see, the database has a space in the name, which the migration wizard doesn't agree with.

Is there any workaround for this issue? I would really like to work with this database in mysql workbench.

Thank you


Options: ReplyQuote

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.