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.

migrated from stackoverflow.com Dec 26 '16 at 19:03

This question came from our site for professional and enthusiast programmers.

  • 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