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
    – Ali Rasheed
    Commented Dec 26, 2016 at 17:43
  • Are you using any tool?
    – McNets
    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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.