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.

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

Yes you can migrate database and rename database name.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy