I'm using SQL Server Migration Assistant for data migration from MySQL to SQL Server. I would like to know whether it is possible to migrate data from databases of different names but tables inside databases have the same names.
Sql-server – Migrate data from MySQL to SQL Server, database names differ
migrationMySQLsql server
Related Question
- Sql-server – Extra column when migrating Sybase databases to single SQL Server database
- Sql-server – Don’t delete exist data with SSMA
- Mysql – Migrate a schema structure from one server to another MySQL
- Sql-server – Why SQL Server Migration Assistant keeps crashing on the ‘Migrate Data’ step
- Sql-server – Migrate on-premise SQL Server databases to Azure SQL Database
- Sql-server – Does Data Migration Advisor migrate system databases
Best Answer
Yes you can migrate database and rename database name.