From:       To:      

Home > Documentation > SQL Server to MySQL > FAQ

All MySQL table names include schema name as a prefix. How to avoid it?

By default SQL Server to MySQL converter lists all tables found in the database. Because different schemas could contain tables with the same name, the application composes full table name as [schema name].[table name] to guaranty that it is unique. If you need to work with tables owned by the specified MS SQL user, select "View tables owned by the user" checkbox on "Select Databases" wizard page. This will force the program to not include schema name as prefix.

Have more questions? Contact us