I have designed a database over mysql which contains Arabic characters using UTF8. However, I decided to migrate my data from mysql to SQL Server Express edition. I have downloaded DTSWizard to do the migration but I am facing several problem:
1- Data Type differences between the 2 Dbs (look at the attached file)
2- one of my tables "Customer" table has Arabic characters and when I display it, it get displayed ???
Now, I cannot extract the customer data and insert it into SQL like that.
What are my options in term of migrating the data successfuly and making sure that the customer names in the destination DB is not ????