1

What are the factors affecting the migration of database from MS SQL Server to MySQL causing corrupted files?

I transferred my database from MS SQL Server 2012 into MySQL on the same Windows PC. I used the default migration wizard and it proceed. But when I export one of the media file to my local disk, I cannot open it and it prompt that the file is corrupted.

  • Add more details, please. – Rick James Feb 6 '17 at 6:04
  • For example, I migrated my database from MS SQL Server 2012 into MySQL. It proceed and finished the migration, but ending up on corrupted files, specially the BLOB. Are there any factors to be considered on migrating into different platform? – Tero Feb 6 '17 at 6:10
  • 1
    Corrupted schema syntax? Corrupted data? What kind of corruption? Sample of the data (before and after)? How did you do the migration? Windows versus Unix versus Mac? Which direction? CRLF versus LF vs CR? – Rick James Feb 6 '17 at 6:29
  • 1
    As currently asked, your question appears too broad. So, whatever details you are adding to it, please do so using the edit link rather than in comments, thanks. – Andriy M Feb 6 '17 at 6:31
  • 1
    @RickJames: I'm not sure but as the OP is asking for factors to consider (rather than for a solution to a specific corruption issue), some of the points you are asking about may actually be part of the answer. – Andriy M Feb 6 '17 at 6:32

Your Answer

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

Browse other questions tagged or ask your own question.