Solved

Migrating Arabic Data from MySQL to Sql Server Express edition

Posted on 2009-07-02
15
498 Views
Last Modified: 2012-05-07
Hi,
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 ????

Thank you

Report1.txt
0
Comment
Question by:cooldude87801
  • 8
  • 7
15 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24762530
why don't you use any migration tool?

have a look at this one

http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24762547
0
 

Author Comment

by:cooldude87801
ID: 24764338

but what kinda I do about the Arabic characters that are not displayed correctly
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24764733
you have to set arabic collation for your database
0
 

Author Comment

by:cooldude87801
ID: 24764782
which database we are talking about? mysql or SQL Server

I am afraid by pulling the data from mysql and inserting it as is into the SQL Server I will end up with ???? for customer names
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24764797
you have to set collation in SQL Server database

0
 

Author Comment

by:cooldude87801
ID: 24768045
Hi RiteshShah,

I migrated some of the data to SQL Server using your first suggestion, but again the content is displayed in ????????

even though the collation is Arabic_CI_AI

by the way, I am going to use this table with A desktop app using C# so I won't view it over the internet.

I would appreciate any suggestions
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 31

Expert Comment

by:RiteshShah
ID: 24769271
because your database might be Arabic what about table collation or column collation, you have to change those also.
0
 

Author Comment

by:cooldude87801
ID: 24770640
Dear RiteshShah,
I have changed the collation on the columns to Arabic_100_CI_AI but still the data is displayed in a weird way
CustomDB.jpg
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24770648
well in that case I am bit stumped
0
 

Author Comment

by:cooldude87801
ID: 24770662
could it be the encoding that i am using in SQL Server is not correct?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24770667
not like that, the only thing is, you are not selecting proper collation, you have to use the collation in sql server whose character was used in your MySQL
0
 

Author Comment

by:cooldude87801
ID: 24770684
The collation character I used in mySQL is utf8_general_ci, so what that can be in sql server?
0
 

Author Comment

by:cooldude87801
ID: 24811150

I am still waiting for a solution guys....I need your help
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24811183
cooldude87,

I am sorry I can't help further in this issue and seems like other expert have missed this question, it would be good that if you close this question and raise new one so other expert can see new question and help you out.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now