Solved

Migrating Arabic Data from MySQL to Sql Server Express edition

Posted on 2009-07-02
15
509 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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
 
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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