Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Migrating Arabic Data from MySQL to Sql Server Express edition

Posted on 2009-07-02
15
Medium Priority
?
521 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

610 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