Solved

Migrating Arabic Data from MySQL to Sql Server Express edition

Posted on 2009-07-02
15
501 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

786 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