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.
Yes you can migrate database and rename database name.
IDENTITYand MySQL uses
AUTO_INCREMENT... be aware