Solved

Migrating Arabic Data from MySQL to Sql Server Express edition

Posted on 2009-07-02
15
495 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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 to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Copy Database Wizard 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.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

10 Experts available now in Live!

Get 1:1 Help Now