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.

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

1 Answer 1

0

Yes you can migrate database and rename database name.

Your Answer

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