0

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.

Improve this question
2
  • If you are doing it via script then it won't cuz there is a syntax variation. as SQL uses IDENTITY and MySQL uses AUTO_INCREMENT ... be aware Commented Dec 26, 2016 at 17:43
  • Are you using any tool? Commented Dec 26, 2016 at 19:12

1 Answer 1

Reset to default
0

Yes you can migrate database and rename database name.

Improve this answer