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
## SQL Server
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
Last activity: Feb 10, 2022, 11:14 AM