Sample Header Ad - 728x90

Table names when migrating MySQL to Microsoft SQL Server

3 votes
1 answer
1124 views
I've just migrated a MySQL database over to Microsoft SQL Server using Microsoft SQL Server Migration Assistant for MySQL. For some reason the table names in SQL Server are not named the same way as in MySQL. If my table is named *accounts* in MySQL, if will after the migration be called *databaseName.accounts*, why is that? It makes it pretty annoying since I have to change the table names in all my queries to *database.OldDatabaseName.Table* instead of just *database.Table*. ### MySQL enter image description here ## SQL Server enter image description here Or can I somehow rename the tables? Because when I click rename I can only edit the last part: 'accounts'.
Asked by Mads (133 rep)
Feb 9, 2022, 12:19 PM
Last activity: Feb 10, 2022, 11:14 AM